Pivot Table - data results that equal zero to be hidden

D

David ML

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
==>> (say result = 0 = +54, -4, -50) which is what I want to hide

DELL -100

HP 0
==>> (say result = 0 = +133, -122,-11) which 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table: How do I hide calculated items that result in zero? 0
Using VBA to create charts 1
Hidding zero values 4
Supress Zero Values on Calculated Item in Pivot Table 0
VBA Pivot Table Error 1
Playing back a Pivot Table macros 2
Suppress Zero 2

Top