7 Replies Latest reply on Feb 13, 2018 4:32 AM by Anmol Parimoo

    12 Rolling Total

    Roxana Tsirikhova

      Hi,

       

       

      I am relatively new to Tableau and am trying to calculate the sum of prior 12month for, let's say, sales.

       

      For example I have data from Jan15-Jan18 and for each month I want to calculate the total sales for the month + prior 11 months ( for example- against Jan18 total from Feb17 to Jan18, against Dec17 the total from Jan17 to Dec17). The final date is set separately as a parameter and will change monthly. I would need to use the calculated amount in other calculations in the future as well.

       

      I tried a few things including the data filters, groupings but cannot get this to work. I included a sample workbook with the dummy data ( unedited).

       

      Hopefully this is a way to achieve this?

       

      Thank you in advance.

       

      Rox