4 Replies Latest reply: Jul 6, 2018 9:54 AM by Sunny Talwar RSS

    Pareto Analysis for product

    Stefania 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!