I currently have a report for Quotas by sales rep and date (Mm/yy)

A separate report for Sales by Mm/DD, and Rep.

I can do pivot tables independently for quota and sales; however when I attempt to add sales to the quota pivot to determine the variance by month Sales vs. quota, the sales is summing the entire year not by month. 

I believe that a query to get a sum of sales by month is the route I should take AND then merge to the quota table. yet this is where I am not able to get the proper sum of months for sales.