Skip to Content
Former Member
Sep 19, 2011 at 12:45 PM

Creating hierarchy on measures



I have a requirement where I need to drill-down or Hide/Expand on measure.


Hierarchy expanded view.

Sales Europe

Sales USA

Sales Asia

Sales Total

Hierarchy normal view.

Sales Total


In the above example I need to hide detail rows (Sales Europe, Sales USA, Sales Asia) and only show Sales Total but when I expand all the detail rows should be visible. All the above rows are measures.

I can do it very easily in BEx by creating a structure with keyfigures and include detail rows under the total row as next level in the hierarchy.

Does any have any idea how this can be done in WebI?

Very thankful to any help.


Edited by: Suman Vemula on Sep 19, 2011 2:45 PM