I hope someone can help me. We are building an income statement, and used hierarchy to define the parent accounts.
The problem now is that we have 10 colums, and after multiple expansions it doesn't look good.
So I want to know if it is at all possible to expand a Pivot table into the same column?
Please see the attached QVW as an example of the data i have, and the attached picture as what i would like to achieve.