3 Replies Latest reply on Dec 14, 2018 4:14 AM by Norbert Maijoor

    How to get Prior Month data?

    Veera Veeru

      Hi, Can anyone help me with the below query? I have data from Jul'17 to Jun'18, my current month is Jan'18. I would like to have prior month data (calc field) which is Dec'17 in order to have month on month variance. Period Data Jul-17 1668 Aug-17 1729 Sep-17 2266 Oct-17 1818 Nov-17 2462 Dec-17 2074 Jan-18 1559 Feb-18 2383 Mar-18 2045 Apr-18 2483 May-18 2438 Jun-18 1727 Thanks in Advance Regards, Veera