6 Replies Latest reply on Sep 6, 2018 10:34 PM by Shinichiro Murakami

    Previous values for year,quarter, month

    Arnab Chaudhury

      Hi Experts,

       

       

      I have a requirement to show the previous values of a year, quarter and month.

      I have used lookup but it does not give me the expected result due to the filter applied.

      Also the date periods as not date datatype, they are  string data type, e.g. FY2018, FY2018 Q3, FY2018 JAN

       

       

       

       

      Currently the values for year is appearing as expected when both FY2017 and FY2018 is selected.

       

      But the deselecting FY2017 prepaces previous value with null.