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

    12 Rolling Total

    Roxana Tsirikhova




      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.