Pivot Table

[#1]

Hi all,

    How to hide expressions in pivot table

Thanks & regards,

Nagaraju

[brijesh1991]

Hide is straight table functionality, you can't do with PIVOT.

You can manage pivot functionalities in straigh table by writing multiple expressions

[jagan]

Hi,

You can hide expression column in pivot table using the macro

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

Regards,

Jagan.

[#4]

Hi Nagaraju,

  There is a option called Conditional in Expression Tab use this option to hide until the condition satisfies.

[#5]

Expressions can be conditionally hidden by checking "Conditional" check bx in expressions tab on pivot table.

But this option is available from QV 11 and not in the versions below.