Rearranging the order of a hierarchy on an inline Pivot Table
SummaryRearranging the order of a hierarchy on an inline Pivot Table
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.