3 Replies Latest reply on Sep 10, 2018 6:59 AM by Shinichiro Murakami

    Display last 12 months data from month selected from Show Filter

    Adithya Vardhan Tirunagari

      I am using Ver 9.3


      I have created a date parameter and created a following calculated field


      if YEAR([Order Date])=YEAR([Year]) and MONTH([Order Date])=MONTH([Year])       \\Here year is a date parameter\\


      DATEADD('month',-12,[Order Date])



      By using show parameter control i get only the single month and year. Ex. If i select June 2014 it shows June 2013.


      But i want all the previous 12 months data displayed till June 2013.




      June 2013

      July  2013

      August 2013




      June 2014.