1 Reply Latest reply: Oct 17, 2016 1:02 PM by Sunny Talwar RSS

    Get all previous month data to current date data when date is selected

    omkar pechetti


      i took year,date as dimensions.

      sales as my expression in my Straight table chart.

      I am trying to get all previous months sales aggregated upto the selected date in chart.

      For Example: when i selected on 15-03-2016 in Date field, I need to get all the previous sales data upto the current date.

      It means i need a single record in my chart when i select on 15-03-2016.which should represent in chart as below:

                          year | date | sale


      I tried using Year to Month(YTD),but it is fetching all the dates upto the selected date.

      Please get me answer anyone there.


      Thanks in Advance.