Compare 2 sets of data - Invoice vs Forecast

[t_man000]

Hi,

I have 2 tabs of data, one called invoice and another called forecast. They both have part numbers, site, DC and customer. How would I make a pivot and graph to show Forecast vs invoice for market category "Beetroot" only for the days in the forecast tab only? Below is the file i'm working with:

******** src="https://onedrive.live.com/embed?cid=3A05896256B2FAC6&resid=3A05896256B2FAC6%213034&authkey=AExf1TLsx-63KEY&em=2" width="402" height="346" frameborder="0" scrolling="no">*********>

I hope the link works.

Thanks