Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Would you be able to share more details as to what issues are you running into?
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?
Would you be able to share a sample where we can see the issue you are having?