4 Replies Latest reply: Jan 9, 2017 9:02 PM by Alec Smith RSS

    RangeSum of Previous Three Months

    Alec Smith

      Hello,

       

      I am trying to create a previous three month aggregation of Charges per row.  The issue is when I filter on the current year of 2016, January is not aggregating the previous months of November 2015,December 2015 and January 2016. I am using the RangeSum function with the Above function with the {1} to ignore the filter selection but, the beginning periods are not aggregating correctly.  The goal is to have a previous three month aggregation per row on the straight table regardless of which year I filter on except for the first year where data for the previous months do not exist.

       

      Attached is the app with the current version of the previous three month expression. 

       

      Any help would be very much appreciated. 

       

      Thank you!