One year slicer to control two different pivot charts with different date columns but same data source?

[deLockloire]

Hey,

I have an excel table with invoices. Invoices has two dates, one is the date of completion, the other is the date when the invoice was actually paid. I need two different charts from this. One that shows revenues according to the first date, and one that shows revenues according to the second date. I can create two pivot tables and two pivot charts out of these easily. The problem is, that if I create a pivot table, it has two year fields (year & year2) and it seem that year = completion date and year2 = payment date. Is there any way to create a year slicer that operates both charts?

Thanks,
deL