5 Replies Latest reply on Dec 21, 2018 11:19 AM by Matt George

    Rolling 3,6,12 Month columns in same view?

    Aaron Valleroy

      Good morning community,

       

      I am working on a project where I need to display the Rolling 3 month, 6 month and 12 month in columns side by side at the same time.  Therefore, I can not use parameters or date filters to achieve this task.  I have attached a workbook with how I have attempted to start this journey.  If anyone can please help me achieve this view it would be greatly appreciated.

       

      Project barriers for rolling calculations:

      1. The data set is not current there is a two month lag in the data.  Therefore, I can not use today() as part of the datediff.

      2. I am needing to calculate the average (number of records) for each given month.  I have struggled to achieve the avg(number of records) in my rolling calculations.

       

       

      Again I GREATLY appreciate any assistance solving this problem as I am often requested to show rolling 3, 6, 12 for side by side comparisons.