Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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