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 dont 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.