Hi,
I am working on Cube 0SD_C03 for the Sales and Distribution Report "Product Group Wise Sales Ratio & Sales Based Product Ranking". There I have to use the following formula.
Sales Ratio=(Total Sales for the Product Group / Its Total sales for month/ year)
so is there any single formula through which it can be calculated for all Product Groups or I have to make the formula for all Product Group Values?
Note: For Product Group, I have Biscuits, Chololate, Jelly, Wafers and 15 more elements.
Regards
Amit Srivastava