Expanding some columns in a pivot table and not all
I wanted to know if it was possible to expand some columns in a pivot table only and not all of them.
I have a pivot table with 4 dimensions and the rest are all expressions. The first three dimensions I want them to be either fully expanded or collapsed based on how the user toggles between the two options. I want to be able to keep the third dimension in the pivot table to NOT be expanded.
I would think to use the Dimensionality() function here but I am not sure if this would work.
If anyone can maybe suggest some ideas on how I can achieve this then that would be great.