9 Replies Latest reply on Oct 29, 2018 3:50 PM by Don Wise

    Running Sum By ID

    maria.schemmel

      Hello All,

       

      I am trying to create a calculated field for a running sum of column "Total" for each of my serial numbers. I can't seem to figure it out. Here is an example in excel of what i am trying to do. The column all the way to the right is what i'm trying to generate as a calculated measure. I want this column to start back at zero for each new serial number. It needs to sum the values in the "Total" column. I'm guessing i need some sort of level of detail expression in my calculated field, which I am very new to. Can anyone help me out here?  I can't attach my actual file because it's for work and I can't share.

       

          

      Serial Number MonthTotal         Serial number Running sum
      111111100
      111111200
      111111311
      111111423
      111111503
      111111603
      111111747
      111111807
      111111907
      1111111007
      1111111118
      1111111208
      222222100
      222222200
      222222311
      222222401
      222222501
      222222645
      222222705
      222222805
      222222905
      2222221005
      2222221105
      2222221227