Hi,

As the users drill down one of the dimensions, I want to show the breakup of each sub member in terms of %age e.g.

Suppose total Sales are 300 and breakup is as follows:
Category A = $ 120
Category B = $ 65
Category C = $ 115


I want that when the user drills down to the 2nd level in the Products dimension (let's say this Level is called Category) then I want the %age of Sales for each category - all adding up to 100

So this is what I should get (for the desired % breakup)

Category A = 40
Category B = 22
Category C = 38


I'll appreciate your help in making such a Calculated field.

Many TIA.