Supress Zero Values on Calculated Item in Pivot Table

S

Simon

Hi,

I have a pivot which uses a calculated item, as a result of the calculated
item the pivot table has grown considerably in that it now displays a lot of
zero's. My data field is revenue, I'm then splitting the revenue with the
ledger field which splits the revenue up as either being "Actual" or
"Budgeted". I've added in a calculated item called "variance" which is =
Actual - Budget. When I did that the pivot table grew considerably and now
there are a lot of zeros. I want to be able to supress/hide the 0 amounts,
is there anyway that I can do this through macro code? if so, how would I
achieve it so that each time the pivot is refreshed any zero values are
supressed.

Thanks.
 

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

PIVOT - refresh pivot based on Field / item 1
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Calculated Item in Pivot table 1
Slicers and Calculated Items in Pivot Table 2
Problem with Calculated item in Pivot Table 0
Problem with Calculated item in Pivot Table 1
Pivot Table Calculated Fields 1
Pivot Table Calculated Field 0

Top