1 2 3 Previous Next 30 Replies Latest reply on Aug 15, 2018 9:29 PM by Aaron Mak

    Cumulative sums over time combined with a date filter

      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?

        1 2 3 Previous Next