Skip to Content
Former Member
Jan 30, 2007 at 06:22 PM

Portion of Sales divided by total sales


Hi Guru's

I have a report that is requiring me to calculate the % of sales. For each material (or Material Group) I have listed the amount of Sales. The user now wants to know for each material what % of sales the product is. So I need to divide by total sales. I just don’t know how to get Total Sales into the line because when I add a row it automatically restricts by the material so I can never achieve the TOTAL.

Any suggestions are greatly appreciated.