Hiding Column in pivot table

[sibin_jacob]

Is it possible to hide a column in pivot table ?

[Anonymous]

You can use the conditional expression box for the expressions to only show them when certain conditions are met.

[Anonymous]

Hi Sibin,

You can use conditional formatting expression or you can write a macro to make coloumn width Zero

Macro would be on expression:

     set chart = ActiveDocument.GetSheetObject("CH01") 'Your object ID

     set p = chart.GetProperties

     set expr = p.Expressions.Item(0).Item(0).Data.ExpressionVisual

     expr.ColWidth = 0

     chart.SetProperties p

[stantrolav]

Write =False() in condition. All Expressions would count for this hided dimension as well.