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,