Hide & Show expression column in pivot table

[abc_18]

Hi,

Is it possible to hide a expression column in pivot table conditionality, but when we click on subtotal(Partial sum)  that column should appear??

[Chanty4u]

hi,

chk dis

Hiding expression column in Pivot table

[Chanty4u]

chk dis tooHow to hide column in expression in pivot table

[abc_18]

Hi,

Thanks for your reply.

But my requirement is like that particular expression should hide, but upon selection on subtotal column(Dimension in which partial sum condition is applied in presentation tab) then that particular expression column should appear.

[abc_18 · Accepted solution]

Hi,

Issue is resolved now.

I have used GetCurrentSelections() and GetPossibleCount() function.

Expression is:

If( IsNull( GetCurrentSelections()) ,0, GetPossibleCount(Dimnsion))