Hide columns in a Pivot table

[#1]

Hi,

In a Pivot table is it possible to hide certain columns when the entire column is empty(null).

I see that option for Straight table(Presentation tab) but could not find any such option for Pivot table.

Please share any relevant information.

Thanks.

Regards,

Rohit Agarwal

[#2]

In properties -> presentation ->

has two options, Suppress Zero-Values and Suppress Missing, i think if you disable those options works to you

[#3]

I have tired doing the same but it does not work for me.

Please let me know if you have any other solution.

Regards,

Rohit

[martin59]

Hi,

If I were you, I created two pivot tables and work with conditionnal showing.

If sum(ColumnToHide)>0, Show PivotTable1, Else, Show PivotTable2.

PivotTable2 = PivotTable1 without ColumnToHide.

Hope that helps you.