3 Replies Latest reply on Nov 10, 2016 5:43 AM by Norbert Maijoor

    Filter showing the last 4 quarters - 1. I.e. a rolling filter showing last 4 quarters but not the current one

    Jan Paulsen

      Hello community,

       

      I want to create a filter that shows the last 4 quarters -1.

       

      Example:

      - when I select 31 Dec 2013 as the end in a time slider (i.e. a date in Q4.2013), the results should be limited to Q4.2012 - Q3.2013.

      - when selecting 15 Jan 2013 the results should be limited to Q1.2012 - Q4.2012

       

      Ultimately, I need to create several filters showing last 4 quarters -1, 2, 3...

       

      Can anyone help?