1 2 Previous Next 22 Replies Latest reply on Jul 1, 2015 9:29 AM by Aalok Jain

    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