Skip to Content
0
Jan 10, 2011 at 02:06 PM

How to make formula for the list of Charateristic values

32 Views

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