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\\

      THEN

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

      END

       

      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.

       

      Ex

       

      June 2013

      July  2013

      August 2013

      ,,

      ,,

      ,,

      June 2014.