Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Sum quadrants in Analysis Services

Author  Topic  kishv Starting Member 3 Posts Posted - 2004-12-15 : 11:41:55 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. something like this 80, 80, 80, 20, 20, 20 121,122,123,124,125,126 80 990 80 991 80 992 20 993 20 994 Customer What i want to do is create a calculated member that sums up the 80 based values on customer with 80 based values from the product dimension. In the above case I should end up with total of 990+991+992+121,122,123. 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 based values for products as well which I don't want. How can I modify the above statement to just give me sum of all product 80 based and all customer's 80 based. Thanks