Rearranging the order of a hierarchy on an inline Pivot Table

Luke Sharma

Summary

Rearranging the order of a hierarchy on an inline Pivot Table

Content

Hi all,

I have a pivot table that features a hierarchy that goes as follows; Gen2 - Gen3 - Gen4- Gen5 (i.e. Gen3 is a child of Gen2 and so on)

Currently my pivot table displays as such;

Where Purple = Gen 2, Blue = Gen 3, Green= Gen4 & Grey=Gen5

I need to some how "flip" the hierarchy so that Gen2 appears at the bottom, Gen3 above Gen2, Gen4 above Gen3, and Gen5 above Gen4. So the order "colour wise" would be Grey, Green, Blue, Purple.

Each parent is essentially a summed total of the children - so each "Green" is a summed total of the values of all of the "Greys" in its group.

I have achieved this in an Outline Pivot table, but the request is for the rows to be Inline, so the children appear directly *beneath* their parent. I have tried using "Subtotals" in place of the parents, however subtotals do not appear to be working.