10 Replies Latest reply: Sep 5, 2016 1:06 PM by Evgeny Stuchalkin RSS

    stuck with aggr function

    Evgeny Stuchalkin

      Hello! I'm using this expression for calculaion of ABC analysis dimension for client base:

       

      Aggr({<Client>}

      If((Rank(Sum({<Client>} Delta),1)-1) / Count({<Client>} distinct total  Client)< abc1, 'A',

      If((Rank(Sum({<Client>} Delta),1)-1) / Count({<Client>} distinct total  Client)< abc2, 'B', 'C')),
      Client)

       

      Works fine, but only in table with ont Dimension. Result looks like:

       

      ClientABCSum(Delta)
      MorisA160000
      DorisB15000
      BorisB15000
      NorrisC10000

       

      I want also to see, how ABC segmet changes from year to year for every client. Like this:

       

      120122013
      Sum (Delta)ABCSum (Delta)ABC
      Moris80000A5000C
      Doris7500B80000A
      Boris7500B7500B
      Norris5000C7500B

       

      Just cant to get any result. Only to display ABC segment for current Year. If selected more than one year, ABC calculated for all amounts of Delta, ignoring the years. How to fix it?