how to prevent expanding one dimension in pivot table

[markuskoessler]

Hi everyone,

I'm working on a pivot table with some dimensions and I would like to prevent the user to expand one of those dimensions. Any ideas how to solve that?

Thank you!

[markuskoessler]

I've found a possible solution.

Within the formula I check the value of the dimension AND the "Dimensionality", which looks like that:

if(DIMENSION1='Name of Dimension' and not Dimensionality()=2,
sum(whatever)

As a Result, I can click on the "+ symbol" which turns into a "- symbol" but nothing else happens.
Maybey someone has a more elegant solution, but I'm happy with that.

Cheers