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