Pivot Table: How do I hide calculated items that result in zero? NOT zero
values but rather the sum of the values which result in zero.

EXAMPLE of top portion of pivot table:

Position (All)

Sum of Position
Instrument Total
MSFT 0 ==== this is what I want to hide
DELL -100
HP 0 =====this is what I want to hide
TOY 131

But I am getting the following error message when attempting to hide the
zero sums: "You cannot hide this selection".

I also tried going into "Position" field, clicked on 'Field Settings' and
attempted to hide the zero however it only lists the VALUES of the positions
and not the SUM of the positions (whose sum of positions = zero is what I
want to hide in the pivot table).... Please help! Thank you!

Click on Pivot Table options and there is a box on the left that says For
empty cells, Show: I usually leave that blank and it'll will come up with a
line (-) in the box. In that options memu for can see and check box for
error values.

"David ML" wrote:

Pivot Table: How do I hide calculated items that result in zero? NOT zero
values but rather the sum of the values which result in zero.

EXAMPLE of top portion of pivot table:

Position (All)

Sum of Position
Instrument Total
MSFT 0 ==== this is what I want to hide
DELL -100
HP 0 =====this is what I want to hide
TOY 131

But I am getting the following error message when attempting to hide the
zero sums: "You cannot hide this selection".

I also tried going into "Position" field, clicked on 'Field Settings' and
attempted to hide the zero however it only lists the VALUES of the positions
and not the SUM of the positions (whose sum of positions = zero is what I
want to hide in the pivot table).... Please help! Thank you!