Pivot Table help needed - applying autofilter doesn't display columns with zero values

[jdmc45]

Hi,

I have a query with Pivot Tables. When I apply an autofilter on a Pivot Table it doesn't show the columns with all zero values, how do I get the table to show these columns?

My motivation for showing these columns with zero values is that I need to calculate some metrics (eg. top left cell of one pivot table divided by top left cell of another pivot table, in %) and so need the pivot tables to be of the same dimension.

Any help on this matter would be much appreciated.

Cheers

 

[kidwispa]

If you go into the PivotTable options menu and where it says "for empty cells show" input a 0. that should make zero values visible...

 

[jdmc45]

thank you very much!