Hide expression in pivot table when all zero values

[godfreydaniels]

Hi,

I have a pivot table with months across the top and two expressions: one that  is monthly, and one that belongs only to months in which a quarter ends.  The users very much want to hide the quarterly measure except for those months for which it applies.  So instead of:

they want to see:

I have tried using 'Suppress Zero Values,' but that seems to suppress the dimension, not the expression. Is there any way to achieve what is shown?

Thanks

[sunny_talwar]

This can be done using Pick(Match()) function with an island table. What you need is to have just one expression so that 'Suppress Zero Values' can take its effect

[godfreydaniels]

Thank you Sunny; could you please elaborate on this?

[sunny_talwar · Accepted solution]

See if this link helps:

How to suppress 0 in expression

[godfreydaniels]

Thanks--that is a clever trick. It seems to break if a second expression is added.  Can it be made to work alongside other expressions that are visible for every month?  It is to go in an ad-hoc reporting table.

Thanks

[sunny_talwar]

You will have to program all your expressions within a single expression using pick(Dim.... As soon as your add two expressions, things might not work.