4 Replies Latest reply on Jul 6, 2017 2:23 PM by amulya.sharma

    Running Total of Count Distinct for entire dimension across Table

    amulya.sharma

      In the attached workbook, you'll see that I'm trying to count the distinct ID's over all preceding years. However, when I use the Running Total across Table calculation, it'll consider distinct values only in that year and add it to the immediately previous year to get the new total.

       

      How do I count the total of these distinct ID's relative to all preceding years from that year? By this logic, 2015 should read 4, 2016 would read 7, 2017 would read 9 on the chart. Thanks.