Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there! I have a pivot table with four dimensions
I would like to see the most internal dimension even when the previous dimension are collapsed.
Is it possible?
I appreciate any help
Greetings!
I don't think so because you can't directly go to 4 th dimension with drill down from 2 & 3. But the other possible solution is create another pivot with 1 & 4th dimensions and apply hide & show based on your requirement criteria.
I don't think so because you can't directly go to 4 th dimension with drill down from 2 & 3. But the other possible solution is create another pivot with 1 & 4th dimensions and apply hide & show based on your requirement criteria.
Hi Jose,
I don't think it is possible to achieve in a pivot table.
What would be the benefit from this feature? Since both tables show data with same granularity, you just can't tell the full context in your second table, because higher dimension values are hidden.
Thank all you guys, it was very helpful.
Here is my solution:
Properties / Presentation / Always Expanded
And Hide and Show Columns on pivot table according with List Box Selection