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% |
