4 Replies Latest reply on Feb 3, 2016 8:50 AM by Michael Nadar

    Moving Calculation with Date filter

    Michael Nadar

      Hey Guys!

       

      We are building a trend report which should show 3-month rolling previous month data. The moving calculation should calculate even with date filter applied.

       

      The moving calculation is not including the previous month values when applying date filter.

       

      LOOKUP on my date filter restricts the quick filter to single worksheet. As I need the filter to be applied on multiple worksheets.

       

      I tried using the LOD in finding the moving calculation beyond the date filter but that didn’t work as well.

       

      I've attached a sample for reference. Appreciate any help.