Select the 1% of the most expensive population

[alejortizp]

Hi,

I try to select the 1% of the most expensive population, I have made a graph of indicators that show how much the percentage of the cost consumes and a pareto table that accumulates the consumption of patients from higher to lower but I have tried to create a dimension that I classify these accumulated percentages of the pareto table by percentiles to filter.

If someone gives me a light I will be very grateful

[sibusiso90]

Can you show me an example of what you are trying to do, you can do it on excel or something just so that I can get the point of what you are trying to do.

[alejortizp]

Hi,

I have a pareto table but i want to select or filter the 1% of the most expensive popultation. Thank you very much if you can help me