1 2 Previous Next 28 Replies Latest reply on May 6, 2017 11:21 PM by Karan Shah

    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 Previous Next