Hi People,

This is my first post. Hello!

Basically, I've been given a task at work - we have VAT invoices going back four years and they need the information breaking down into the months and years and the totals for each month.

In the Excel sheet, I have a list of several thousand amounts that I marked as complete when the invoice comes in. I aim to build the Pivot Table from this information.

How can I have the Pivot Table where there is a table to the left, broken down into the four years and the 12 months and the amounts before the project begins next to each month. I would then like anothe Pivot Table to the right that tells us how much money has come in for each month in each year.

Is this possible? If you could explain how you'd do it, that'd be great.

Thanks for your help.

Lee.