Hello,

I have a requirement in Cutsom Rollup.

I have a Dimension which has two levels, Merchant and Product. i am going to apply the custom rollup in Merchant Level, to calculate the measures based on the formula

Consider the example below -

o MERCHANT PRODUCT QTY TARGET PRICE

o merchant1 product1 1 10.00

o merchant1 product2 5 20.00

So, the custom rollup at merchant level will be ((1*10) + (5*20)) / (1+5). To generalize - SUM(QTY*PRICE)/SUM(QTY). this formula may change for different measure which i am going to use.

Please give your feedback. it would be great if you could come up with some solution/suggestions.

Thanks,
Tol Ran