I am trying to have a Pivot Table where some of the Expression Columns are hidden when the dimension is collapsed. I want one table to show summary level information and then show detail level data when the dimension columns are expanded. Is there a way to do this?
Branch Name Sales Person Buyer Name Buyer Address Order# Units Sold Amt
Using the above headers, I want Branch Name and Sales Person to be collapsable (my dimensions). When those are collapsed, the only expressions that I want shown are the totals for Units Sold and Amt (my expressions). When the user expands the Sales Person column, the Buyer Name, Buyer Address, and Order# are shown as details. It is easy to get one column to be hidden by making it a dimension, so if I make Buyer Name a dimension, it will be hidden until Sales Person is expanded. However, the Buyer Address is still visible at all times. If I make Buyer Address a dimension, then Buyer Name becomes expandable and collapsable which I do not want.
Create a new expression: Dimensionality()
This will diplay numbers. Collapse the dimensions to the levels that you do not wish to see any data in some of the expressions. Take note of the numbers displayed in the new expression.
In the expressions that you wish to hide use a formula if(Dimensionality<> Number, Expression)
Thanks marcsliving, this helps, but it only hides the values, not the actual column. When everything is collapsed the only visible expression columns should be Units Sold and Amt.
I've also tried using the Dimensionality() function in the Conditional with no success.
I have the same problem and I can't find any solution in the Community. This is why I want to reopen this post and bump it back to the pop.
Please help if there is any solution the show/hide expression by using the conditional function for every expression.
Dimensionality() does not work in this field.
Thanks in Advance