6 Replies Latest reply on Dec 16, 2016 8:11 AM by Kwesi Enninful

    Calculate a running sum on rows if current row is 1 else default to 0

    Kwesi Enninful



      I am trying to recreate attached excel view (row 4 colored in Blue) in tableau without using Table Calc.


      Basically, I would like do a running sum on row 4 if the current cell in row 3 is 1 or default to 0 if the current cell in row 3 is 0. Hence, count consecutive weeks if cell is 1 else 0 which I have replicated in attached excel and would like to do same in tableau without using table calculation.


      I don't want to use table calc since I want to apply the fixed or include function to aggregate the data further.