How to classify my products between A, B or C ?

[leonardo_alexsa]

Hi Guys,

I'm newbie here,

I just have a case in Qlikview that i can't solve it, and I need help.

I'm trying to classify my products between A, B or C.

I Sort my sheet descending in "Value", after that I accumulate the percentual about total.

This is the rule to calculation:

A =  until 80% about total

B = until 95% about total

C = above 95% about total

How can I do it ?

Please, take a look my attachment.

Thanks for the help

[sunny_talwar · Accepted solution]

Check out this link

Recipe for a Pareto Analysis – Revisited

[leonardo_alexsa]

This topic helped me a loot.

Thank you!