Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
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...
Need Help
Show and Tell
Tips and Tricks
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

    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. 

     

siddhantk989's avatar
siddhantk989
Helper III
9 years ago

Hi tringuyenminh92

 

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

 

tringuyenminh92's avatar
tringuyenminh92
Memorable Member
9 years ago

Hi siddhantk989,

 

I could not access the file data through that link, could you please check it again?:smileyvery-happy: