3 Replies Latest reply on Sep 6, 2018 12:08 PM by susheela.hegde

    Last value calculation missing in the graph

    susheela.hegde

      Hi All,

       

      This seems like a simple logic but i am missing something here.

       

      I have to show Sum(sales) and Lookup(sum(sales),-1) graphically only for 2017 year.

       

      Now, since the Last sales is a calculation from last month, the data is missing for January 2017 and starts from February 2017 which is right .

       

      Is there a way to show December 2016 sum(sales)  for January 2017 so that the trend starts from January instead of February?