Pareto chart - how to limit pareto chart to show only top 80% cumulative value

[sreelathamohan]

I have a pareto chart (see attachment) and would like to show only top 80%. See attachment - I need to show dimensions only until the yellow highlighted part which is the 80% limit. How do I accomplish that?

[rubenmarin · Accepted solution]

Hi, this can be done if you use an if before the expression to check the cummulative percentage:

If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLineOrBar])

[sreelathamohan]

I tried this earlier but did not work, not sure what I did wrong. But it worked. Thank you.

[Kushal_Chawda · Accepted solution]

may be you need to use this condition in both bar and line expression

If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForLine])

If([ExpressionForCummulativePercentage]<=0.8, [ExpressionForBar])

[sreelathamohan]

Yes that is exactly what I did and it worked. Thank you for your response.