Hi ,

I need help for a great problem.

I want calculate the product's mix in Analysis Manager (Sql Server 2000)

Product Sales %Mix
Prod1 10 7% (10/150)
Prod2 20 13% (20/150)
Prod3 30 20% (30/150)
Prod4 40 27% (40/150)
Prod5 50 33% (50/150)
-------------------------------
Total 150 100%

expression: Sales/Total Sales

i try

[Measures].[Sales ]/sum([Measures].[Sales ]) , but it dont work.

Obs. I have another dimensions: Country, state, Sub products, etc...

Thanks in advance,
Ejs
RJ - Brazil

try this and let me know if it works
(This is based on warehouse cubes in foodmart database)
Create a calculated member in product dimension :-
SUM(descendants([Product].CurrentMember,0,SELF),[Measures].[Warehouse
Sales])*100/SUM(Ancestors([Product].CurrentMember, 1),[Measures].[Warehouse
Sales])

This is similar to what you are trying to do.

"ejs" <ejs_system (AT) bol (DOT) com.br> wrote