Conditionally show/hide expression column based on the expanded or collapsed columns?

[#1]

Is it possible to conditionally show/hide an expression column based on what dimension columns are expanded or collapsed?

[agilos_mla]

You should try the dimensionality() function. Read details in the QV help

Ex. Dimensionality() returns 2 if 2 dimensions are expanded in the pivot.

Grand Total has dimensionality() =0

Michael

[swuehl]

You are talking about a pivot table?

I don't think so.

You can use a condition in your expression using Dimensionality() / SecondaryDimensionality() to execute different code per dimension level (when using partial sums).