Hi,
I would like to make a paretto curve, to see how many % of our products contribute how many % of our sales.
I would ideally like to have the cummulative % of products selected on the x-axis, but i cannot seem to do a count(above(product_code)) to get the number of products, and therefore i cannot get the % of the total number of products.
Does anyone know of a way to do this? what I would like to end up with is something like the image i attached.
Thanks for all your help!!