Forum Discussion
Solved
Sum data based on date range
Hi, I have a date column in my table and a sales column. The dummy data is as follows: Date Sales 10/1/2016 500 9/1/2016 200 8/1/2016 600 1/1/2017 100 No...
Hi siddhantk989,
It's same result, I just change connection and field name from Order Date-> Date to fit with your file with my column fields.
Please find the attachment for the data I am trying to get the results. It is just summing uo the entire data snd showing me for both years 2016 and 2017. sheet1 is the data I am working on while sheet 2 is to verify if the result on graph are correct or not.Dummy data
Hi siddhantk989,
I could not access the file data through that link, could you please check it again?:smileyvery-happy: