12 Replies Latest reply on Sep 24, 2017 6:05 PM by Ashok Ramineni

    Display Latest Quarter in Quick Filters dynamically for each refresh

    Ashok Ramineni

      Hello,

       

      I have searched other related topics, but didnt find answer and hence requesting it.

      How to display latest Quarter of that year in the quick filters by default for every extract?

       

      Scenario:

      Lets say data is available till Sep 2017 which is 2017 Q3 and should be displayed in quick filter as drop down value

      As data gets loaded for Oct 2017, drop down filter value should be changed from 2017 Q3 to 2017 Q4 dynamically by default.

      And for Jan 2018, should change to 2018 Q1 and so on..

       

      I have come up with calc filed..seems it is not working as year changes.

       

      Any suggestions please!

       

      Thanks,

      Ashok.