Sum of Sales between two dates from another table

[schmidtkm37]

Hello,

I need a little help figuring out how to get the sum of sales based on a few dimensions as well as a date range. For example, one table has all of the opportunities and looks like this: 

And the other table has invoice data and looks like this:

And I basically need a column in the opportunity table that will tell me the sales between the close date and close date + 1 year. So I would expect a result like this:

Let me know if I need to clarify anything, thanks for your help!

[mceleavey]

Hi @schmidtkm37 ,

can you post the data rather than just images?

M.

[schmidtkm37]

See attached for the example data.

Thanks,

Kevin

[binuacs · Accepted solution]

@schmidtkm37 

Spoiler

[schmidtkm37]

Hell yeah, thanks man