1 2 Previous Next 16 Replies Latest reply on Jul 31, 2017 11:28 PM by mahesh p

    Previous months sales values as a reference line


      I have a case where I am building  a view where in I will be showing only this months sales value in it. I want to show the previous months sales value for each day in the current month in the view as a reference line.


      I have been trying to get this done with using different things (window calculations, table calculations) but I feel I am doing something wrong or I am going entirely in the opposite direction.


      Can someone please help me with this? Also, I don't want to use any parameters. The current month value changes dynamically and I want to show previous months data based on it.


      Any help is truly appreciated.


      Thanks in advance.


      Okechukwu Ossai

        1 2 Previous Next