How to hide measure depends on column in Pivot Table

[JishnuGS]

Hi,

I want to hide Sum(Sales) for Apple and Sum(Price) for Orange in the below pivot table. Is it possible ?

Please share you thoughts.

Thanks

[edwin]

You can control it in the dimension column, if either apple or orange, make the dim NULL then suppress NULL

[JishnuGS · Accepted solution]

Hi All,

Here is the solution,

Measure = if(Product='Apple',Sum(Sales), if(Product='Orange',Sum(Price),0))