Creating hierarchy on measures

Hello,

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

Ex.

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.

/Suman

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