Pareto Analysis for product

[s_santalucia]

Hello,

is it possible to do Pareto Analysis for the products in stock?

ex.

Aggr(

    If(Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art]),1,RowNo()))<0.8, 'A',

        If(Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art]),1,RowNo()))>0.8 and

        Rangesum(Above(count ({1} [%Art])/count ({1} total [%Art])))<0.95, 'B',

            'C')),

    ([%Art],(=count({1} [%Art]),Desc))

    )

thanks!

[ogautier62]

hi,

look at this :

Recipe for an ABC Analysis

and search in forum with pareto

regards

[sunny_talwar]

Would you be able to share more details as to what issues are you running into?

[s_santalucia]

I have a problem with formula..

on the basis of the turnover, I have to divide the articles in stock. ie according to the ABC analysis, how many items of class A I have in stock?

[sunny_talwar]

Would you be able to share a sample where we can see the issue you are having?