How to limit the pivot table expressions

[vipingarg23]

I have a pivot table in which below are dimensions and expressions:

Category (Dimension)

Region (Dimension)

Area (Dimension)

Total Cost (Expression)

Total Vol (Expression)

By default, pivot table will show both expression but I want, when user expand area dimension, then only he/she will be able to see the total cost (Expression) otherwise Only Total Vol should be visible.

[ecolomer]

Is that you need??

[vipingarg23]

Thanks Enrique for your quick answer. You are almost right but Vol expression should not be visible at all. Here it is visible as blank. Blank column should not be visible. Whole column should be disappear. I am trying to do this through dimensionality() but it is not working.

[ecolomer]

Try with this expression:

=if(dimensionality()=0,sum(Vol),null())

[ecolomer · Accepted solution]

the file qvw, without white() text, and expression with dimensionality()=0

[vipingarg23]

Perfect....Thanks Enrique for your help..