var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Custom Rollup Requirement
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.