12 Replies Latest reply: Dec 11, 2017 6:15 AM by Stijn Valkenburg RSS

    Rolling 12 months based on user date selection

    Stijn Valkenburg

      Hi all,

       

      I am trying to create a linechart. Based on the date that the user chooses, I need to display the current rolling 12 months and previous rolling 12 months. This also means I need a dynamic x-axis.

       

      Right now I only have

       

      Rangeavg(Above(sum(Sales), 0, 12))

       

      Which should be the current rolling 12 months for the sum of sales.

       

      Any ideas?