Hi,

I have a view that is customer as rows and products as columns. I have
a calculated member that works out a 80/20 split on both axis based on
the total level. (e.g If (Product.member/Total Product) <0.8 then 80
else 20)

This is the view I have in a report

80 80 20 20
Product X Y W Z
Customer
80 A 200 50 50 50
80 B 200 50 50 50
20 C 200 50 50 50
20 D 400 100 100 100


What i want to do is create another calculated member that sums up the
80 % split based on customer with 80% split based from the product
dimension. (first 2 rows and first 2 columns) In the above case I
should end up with total of 200+200+50+50=500. In excel I could use
SUM(D17:E18). How can i do this in MDX

What I have so far is

sum(filter({[Customer].currentmember},[Measures].[Customer
80-20]=80),[Measures].[Valuex])

Problem is that this gives me the 20 % split of products which I don't
want. How can I modify the above statement to just give me sum of all
products with a 80 split and all customer's that are 80 split.

Thanks

Maybe something like:

[Measures].[Customer 80-20]=80),
sum(filter([Product].[ProdName].Members,
[Measures].[Product 80-20]=80),
[Measures].[Valuex]))

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!