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.
