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

    ankit.ravi

      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