6 Replies Latest reply: Apr 4, 2017 4:17 AM by Matteo Demartini RSS

    Cumulative count distinct

    Matteo Demartini

      Hi guys,

       

      I have to calculate a cumulative count distinct from the very beginning of my data. The "distinct" has to consider the whole data set of course.

       

      I am currently using this formula:

       

      if(count(distinct [Number of Active Suppliers])<>0,num(count({<MonthYear={'<=$(=max(MonthYear))'},Year,Month>} total <MonthYear>distinct [Number of Active Suppliers]), '#.##0'))

       

      which is fine for monthly values, but it does not work when I make multiple selections on months (for every month I get the value of the last one selected).

       

      Any idea?

       

      Many thanks,

      Matteo