4 Replies Latest reply on Aug 2, 2016 2:34 AM by Dilyana Suleymanova

    running total table calculation

    Dilyana Suleymanova

      HI there,

      I have follow data set:

       

      wdemDate
      WDEM111101.04.2016
      WDEM111101.04.2016
      WDEM1211101.04.2016
      WDEM1211101.04.2016
      WDEM131101.04.2016
      WDEM151101.04.2016
      WDEM111101.05.2016
      WDEM1211101.05.2016
      WDEM 166101.05.2016
      WDEM129101.05.2016
      WDEM651101.05.2016
      WDEM371101.05.2016
      WDEM129101.05.2016
      WDEM651101.05.2016
      WDEM371101.05.2016

       

       

      I would like to calculate runing sum of unique  wdems per month. If I calculate  it on myself I have follow results:

       

      April                                May

      4 unique wdem               8 ( 4 unique wdem from april + 4 unique wdem from may  )

       

      If I create running calculation in tableau I have follow results:

      Tableau just prove all unique wdem per month and summarise numbers at the end. With the "Running_SUM"  Tableau cannot recognise already existing wdem from april in may.

       

      Doese anybody have any idea which formula is correct for my calculation?

       

      Thank u!

       

       

      Best

      Dilyana