Not sure if this is the right forum, but -

Have a pivot table in which I've created a calculated item.  The data set
contains several different data groups, and I use an attribute field as a
page field to select the group of interest.  So far, so good.

Then I create a calculated field of the type Profit by subtracting Cost from
Price.  When I do so, the page field no longer selects the group of
interest - rather, the whole data set shows up, regardless of page field
election.

In looking at the calculation results, if I subtract Cost [when tests True
for Empty] from Price [also when tests True for Empty], I nonetheless get 0
for the resulting Profit.  In other words, using basic formula Profit -
Cost, I get 0 as a result when Profit and Cost are empty.  This appears to
be causing every record to appear when using a page field, presumably
because every record has a non-empty element.

Using the formula (Price + Cost <> 0, Price - Cost, ""), I get Error# for
Profit when Price and Cost are empty, and every record still appears when
using a page field.  One thought was that perhaps there is a way to set up a
calculated item formula such that it stores "Empty" rather than 0 or "".
However, if there is, I can't find it anywhere.  I could perhaps write some
code to do a record by record check for the error and make that item
invisible, but would much prefer to resolve this using standard methods
rather than adding a custom work-around.

Ideas??

Thanks,
George