6 Replies Latest reply on Mar 13, 2012 12:53 PM by antoinerealimpact

    Issue displaying an embedded running sum



      I have a dataset containing:

      - 2 measures REVENUE and REVENUE_RUNNING_SUM*

      - 3 dimensions CITY_NAME, DATE_DAY, DATE_WEEK_YEAR (week of year corresponding to this specific day)


      I'd like to create a chart showing the REVENUE and REVENUE _RUNNING_SUM for each DATE_WEEK_YEAR

      However, when I do that, Tableau produces a wrong result (the running sum is way too big).

      I have tried to play around with Table Calculation but it doesn't work


      Does someone understand why it displays the wrong result?


      Thank you in advance for your help,




      Note: *I know I could calculate a running sum in Tableau, and I don't have to do it in my database.