5 Replies Latest reply: Jun 13, 2016 5:10 AM by Stefan Wühl RSS

    Part of the revenue coming from the top 1% of the customers (top1% in volume)

    Alexandre Charpentier

      Hi,

       

      This is the data:

       

      FiscalYearBusinessCustomerIncome

      1213

      A

      A

      1$

      1213

      AB2$
      1314AA4$
      1314AB3$
      1415AA5$
      1415A could be B....B6$

       

      I would like in a straight table with:

       

      Formula121313141415
      =count(distinct Customer)Number of customer300350400
      =round(count(distinct Customer)/100)Top 1% of customer in volume344
      =sum({<Customer={"=Aggr(Rank(Sum({<Business={'A'}>}Income),1,1),Group)<= TOP1% "},Business={'A'}>}Income)/sum({<Business={'A'}>}Income)Part of the total revenue coming from the top 1% customers (i.e Revenue with rank max = count( distinct customer)/100)

       

       

      My issue is to take the top 1%. I made a variable like this:     vRankmax: round(count(distinct Customer)/100)   and used   $(vRankmax) in the formula, but it's not working. Can you help me please? Thanks.

       

      Best regards,

       

      Ludo