Calculate the total in Claculated measures -
09-04-2003
, 06:26 AM
I am having a tough time in building a calculated members in summing
up the Average price(another calculated members).
The cube data I have with me is look like this
kg(MEASURE) price(measure) Average(cal. measures
=price/kg)
Category
Item 1 3 18 6
Item 2 3 27 9
Item 3 4 16 4
Total 10 61 19
The problem I am having is I want to total-up all the average price
(6+9+4=19), the 19 will be used the total for the percentage each
Item's Average Price contribute.
For the total Average Price,I am using the following MDX in the
calculated measures
sum({[Product].currentmember.parent.children,[Measures].[Average]}
The result I got is 6.1 (60/10) instead of 19. Is there any
solutions for this problem? Please help me
Thank you very much in advance!
Ian |