Expand/Collapse dimension with same value

[#1]

Hi, it is any way to expand/collapse a dimension value and keep other dimensions with the same value in the initial state?

For example, I have this pivot table:

When I collapse in "Producto" dimension the value "AFT-PTS-BUY":

Every fields with value "AFT-PTS-BUY" collapse. Is possible to avoid this behavior?

Thanks.

[tresB]

I guess, not possible.

[mrossoit]

Hi,

you can only expand/collapse all nodes through macro (PivotAlwaysFullyExpanded method). There are no others methods that could help you in this way.

I red that is possible to use a bookmark and check Include Layout State but I never did that:

Expanding only first level of Pivot table

Hope it helps.

MR