October 13, 2002 at 11:43 pm
Hello
I have a sales cube where I have Sales item and item levels etc. Fox example, Sales item can be a crate of 2 pepsi bottles and Item can be a single pepsi bottle. A single Pepsi bottle can have sub levels like the label, cap , and the actual drink inside. I want to know the the share of sales % for each of the item for a particular sales item. (Forgetting the third level). First 2 levels are enough. For example 1 crate contains 2 bottles. So each bottle contributes 50% of the actual sale.
Please reply me ASAP, if you come out with any clue.
Thanks and regards,
Anbu
October 16, 2002 at 6:27 am
I post this to be more specific and clear about the problem. This is the sales info for year 1995 and 1996.
USA 5000 6500
Boston 900 1100
Buffalo 300 200
California 2000 3500
Los Angeles 500 900
Now if I take 1996 sales and the share of % Boston could be 1100/6500 *100 and so on.
Let me know if you get any clue.
October 16, 2002 at 8:28 am
Use a calculated member. If your geographical hierarchy is called 'Location', you would need to add the following MDX expression.
([Location].CurrentMember, Measures.[Sales]) / ([Location].CurrentMember.Parent, Measures.[Sales])
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply