Marking Pareto Chart Percentages

[Erick Perez]

Hello,

Nice to greet you, can you help me with the following question please.

I have a Pareto sales chart, I want to automate the selection of 20%, 80% and last 5% of sales.

I am using document property in a Drop-down list to select the necessary percentage and filter the data with a Rule (Show / Hide items) in the properties of the graph.

When the data is filtered, the order of the "Cumulative Percentage" curve is reversed, and I cannot identify why and how to correct it.See screenshot.

Also note that selecting the option to see 20% does not mark 20% of the sale, but marks the categories with a value less than 20% for example. As you could select 20% of sales regardless of category.

 

Thank you very much for your help and time.

Best regards,

Erick Gerardo Perez