11 Replies Latest reply: Sep 16, 2010 7:33 AM by AndreaPeretti RSS

    Aggregate Size (ClassesABC %)

      I create classes ABC buyers in size.
      Class A should be buyers making 80% of sales, class B buyers making 15% of sales and class C on 5% of sales.
      Can you help

      exerror loading image:

      LOAD * INLINE [
      Buyer, Sales

      jonh, 100
      mario, 22
      luca, 32
      ven, 3
      trist, 213
      giulia, 21
      andrea, 54
      manuel, 76
      antonio, 76
      enrico, 765
      fabio, 54
      valeria, 43
      lino, 98
      pino, 5
      tino, 4
      serio, 3453
      ];

        • Aggregate Size (ClassesABC %)
          Miguel Angel Baeyens de Arce

          Hello Andrea,

          You may use something like the following expression as dimension in your chart:

           

          =If(aggr(Sum(Sales) / Sum(TOTAL Sales), Buyer) * 100 > 80, 'A', If(aggr(Sum(Sales) / Sum(TOTAL Sales), Buyer) * 100 > 15, 'B', If(aggr(Sum(Sales) / Sum(TOTAL Sales), Buyer) * 100 > 5, 'C', 'Other' )))


          and

           

          Count(DISTINCT Buyer)


          as expression.

          It should return a table where you have different classes and the number of buyers per class.

          Hope that helps.