I need to do a pareto, the pareto part is easy using rowno() and sorting by sales, but I have a problem now and I haven't been able to find an answer, I need to order my Straight Table by Product, but need the pareto column to have the right number as if it would be ordered by sales.
I want to do this, the problem is that I don't know how to calculate the pareto without ordering by sales.
Product | Sales | Pareto |
---|
A | $30,000 | 85% |
B | $10,000 | 100% |
C | $80,000 | 40% |
D | $60,000 | 70% |
E | $20,000 | 95% |