Automatically returns data for past 18 months according to the selected month

• Jonathan Mallia

  SSCertifiable

  Points: 5192

  More actions

  May 29, 2015 at 1:33 am

  #317757

  Hi everyone,

  Is there a way to get the last 18 months' values when the user selects one particular month?

  For ex. if the user selects May 2015, it will return the Sales as per the following:

  Month Value

  May 2015 5,677

  Apr 2015 9,700

  Mar 2015 2,632

  ....

  ....

  Dec 2013 678

  Nov 2013 2,511

  Thanks for the insights!

  Jon