Hi!
I have some problem creating a calculated member in Analysis manager!
I have several dimensions (Products, Markets, MarketSize,...). Then I have mesures(SalesQ, P,...).
Measure P tells me if the product is present in the specific market.
e.g. if IDMarket 1001 has for IDProduct 123 value of P=0, means that the product 123 is not present in the market 1001. If the value of P is bigger than 0 means that the product is present and it has some salesQ.
The problem:
What I need is, SUM of all SalesQ for all Products, only for the markets where P>0 and
divide it with SUM of all SalesQ for all products in all markets.
I have some problems doing that! If anyone with some IDEA??
thanks!
Bye
Andrej
I have some problem creating a calculated member in Analysis manager!
I have several dimensions (Products, Markets, MarketSize,...). Then I have mesures(SalesQ, P,...).
Measure P tells me if the product is present in the specific market.
e.g. if IDMarket 1001 has for IDProduct 123 value of P=0, means that the product 123 is not present in the market 1001. If the value of P is bigger than 0 means that the product is present and it has some salesQ.
The problem:
What I need is, SUM of all SalesQ for all Products, only for the markets where P>0 and
divide it with SUM of all SalesQ for all products in all markets.
I have some problems doing that! If anyone with some IDEA??
thanks!
Bye
Andrej