I have a requirement where I need to drill-down or Hide/Expand on measure.
Hierarchy expanded view.
Hierarchy normal view.
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