You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Rearranging the order of a hierarchy on an inline Pivot Table

Question
14
Views
0
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!