4 Replies Latest reply on Nov 7, 2018 4:26 AM by Tim Dines

    'Date' axis as per user selection (from a parameter)

    KK Edla

      Hi all,

       

      I want the axis to show lat 12 months data based the user's selection; by month, starting with the same date last month (selected date) and going back 12 months.

       

      I'm attaching a workbook for reference.

       

      If a user selects a date '10/15/2018' then the axis headings I want to see are

       

      09/15/2018

      08/15/2018

      07/15/2018

      06/15/2018

      05/15/2018

      04/15/2018

      03/15/2018

      02/15/2018

      01/15/2018

      12/15/2017

      11/15/2017

      10/15/2017

       

      Appreciate your help!

       

      Thanks,

      KK