3 Replies Latest reply on Apr 7, 2020 4:09 AM by Budi Lubis

    Dynamic date last six month

    Nikunj Sharma

      Hi Friends,

       

      My query is I have to make a cross tab of sales data which can show the data of last six month and once the current month is completed it should dynamically change in that manner

       

       

      for example from today last six month data

      April, March, Feb, Jan, Dec, Nov,

       

      once the current month will change means in may month the cross tab should populate the data in the manner like

       

      May,April, March, Feb,Jan, Dec

       

       

      and this way it will goes

       

       

      how can i attain this