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?