This content has been marked as final. Show 2 replies
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?