Expanding some columns in a pivot table and not all

[#1]

Hi

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.

Thanks

[gonzaloruizgonz]

Hi Rajesh,

Have you resolve that?

BR//Gonza

[Margaret]

I want to know too.