2 Replies Latest reply on May 18, 2016 7:07 AM by mortenbodaugaard.jrgensen

    cumulative sum to always start at zero from the earliest date

    Aldo Fontana

      Hello,

       

      given a data source with a date field and a numeric value field. I know how to use tableau's advanced table calculations to calculate the cumulative sum of the value over time.

       

      Now however, I create a worksheet and add a filter to filter the worksheet by a date range. The problem is that the cumulative sum is reset to zero based on the left-most date in the *filter's* date range. I want the cumulative sum to always start at zero from the earliest date in the datasource itself, even if the worksheet is filtered by a different date range.

       

      Anyone have a suggestion?

       

      Thanks

      Aldo