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

omkarvamsi — Mon, 17 Oct 2016 07:54:28 GMT

Hi,

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

2016|15-03-2016|XXXX

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.

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

sunny_talwar — Mon, 17 Oct 2016 17:02:35 GMT

I think you can look into the possibility of using The As-Of Table