Is it possible to fix the most internal dimension on pivot table?

[#1]

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!

[#2 · Accepted solution]

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.

[nagireddy_qv]

Hi Jose,

I don't think it is possible to achieve in a pivot table.

[swuehl]

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.

[#5]

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