3 Replies Latest reply on Feb 12, 2019 2:40 PM by Darren Braynard

    Accumulation with Dynamic Filter

    Darren Braynard

      I am trying to create a calculation that will perform an accumulation of previous values across a date (day) dimension. However, the accumulation only considers the latest value for each of the ModelNames.

       

      This is a sample input:

       

         

      SessionIDModel NameDayTotal Items
      1A150
      2B1100
      3C2200
      4B3105
      5A451
      6B5106
      7A653
      8B7110
      9C8230
      10A859
      11B9115
      12C10240
      13A1162
      14B11120

       

      Here is the sample output of the accumulation calculation:

        

      DaySum of Last Total Items
      1150
      2350
      3355
      4357
      6359
      7363
      8399
      9404
      10414
      11422

       

      For example: for the result table, the "Day 7" is calculated by adding together (B=110 + A=53 + C=200) = 363. As a side note, my underlying data has many more dimensions than the ones presented in the sample input.

       

      Help would be VERY appreciated.

      Thanks