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

    Issue displaying an embedded running sum

      Hello,

       

      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,

       

      Antoine

       

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