You need to sign in to do that
Don't have an account?
aknight
Product line sales as a % of total sales
I need a formula that will show me the percentage breakdown of a product mix within the whole product line. I have a report that shows me the different products by quantity sold for the year and the grand total for all product lines, but I cannot figure out how to show this as a percentage, any ideas?
ie. Product A: Sales 50, Product B: Sales 130, Product C: Sales 17. Total Sales 197
Product A: 25.39%
Product B: 65.98%
Product C: 8.62%
Andrew
I think you can use a report formula like this:
{!TOTAL_PRICE:SUM} / {!AMOUNT:SUM}