I am trying to match the exchanged rate based on the date of the sales data and convert the currency to GBP, Then make a pivot table to show sales fro

[drummerGuy123]

[FONT=&quot]Attached is a set of sales data. The task is to produce a graph showing the total paid orders in GBP, with the months across the horizontal axis and sales volume (including postage) on the vertical axis. The graph should aim to compare year on year performance and I need a slicer to be able to filter results by Marketplace. Firstly, I need to convert the currency (use a vlookup - exchange rates are included). After that use a pivot table to create a pivot chart[/FONT]
Here is the file, I hope someone can help.

https://www.dropbox.com/s/r3bfl1210co14cd/Excel 2 MATCH SUM Problem.xlsx?dl=0

 

[RasGhul]

Here's a mock-up version of your sheet, see if it suits.

https://www.dropbox.com/s/dk6qsgkj5r3l9ui/Excel 2 MATCH SUM Problem_JP.xlsx?dl=0