11 Replies Latest reply: Jan 17, 2018 7:30 AM by satish rathod RSS

    Sum of sales of previous year MTD

    satish rathod

      Hello All,

      I want the Expression for the 'Previous Year Month to Date'

      However if I select a particular month, it should show me the Value From the

               'Start of the Previous Year to the End of the Selected  Month'.

      E.g :      This Year Being 2018, if i Select the Month May, it should show me the values .i.e Sum(Sales) from                    1st Jan 2017 to 31st May 2017.

                Date Field in the Data is 'Order_Date'.