Skip to Content
Former Member
May 09, 2016 at 04:55 PM

Expand hierarchy to new / separate columns


I'm desperately looking for a possibility to expand hierarchies (by clicking "+") to a new column. Currently the expansion is only done in the same column. If I disable to display the level I expanded, I will lose this information.

I need this view for Pivot tables in Excel. This is similar to the "Classical Layout" or "Tabular Form" in Excel 2013.

To make this clear, my goal is the following:
I have for example two hierarchy nodes on level 1 --> now I extend both nodes and display only level 2 --> I can't see the text of level 1 node anymore --> my goal is to have the text of level 1 in Column A and level 2 in Column B (and level 3 in column C...)

I really hope that someone knows how to do this. So far this is a really great limitation for me.

Thanks a lot and best regards!