8 Replies Latest reply on Dec 31, 2016 1:09 PM by Yuriy Fal Branched from an earlier discussion.

    Re: Rolling 12 month window

    Helen Rowson

      Hi Yuri,

       

      I've been following this thread and wondered if you may be able to help me?  I'm very new to Tableau.  I've tried to replicate your methodology except I need to show a rolling 12 month position for every month.  I want the months displayed across the top of my table e.g. April 2015, May 2015 etc and in the value pane below I want to show the rolling 12 month sum for that month.  An example would be for April 2015, I want the value to show May 2014 to April 2015.  In the example workbook I've attached the number should be: 99 for April 2015 (i.e. sum of May 2014 to April 2015 rolling 12 month period, 96 for May 2015 (i.e. sum for June 2014 to May 2015 rolling 12 month period) etc etc.  I've attached my workbook.  I only have data from April 2014 in the workbook so the first rolling 12 month period would be for March 2015 (i.e. April 2014 to March 2015).

       

      Any help you could offer would be much appreciated.

       

      Thank you,

       

      Helen