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.
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.
Thanks a lot for your help. I think the problem was with the date format. The solution is working perfectly fine now.