1 Pivot Table - 3 Pivot Charts with Different Filters

[BigLad]

Hello,

I'm trying to analyse some timesheet data that is being exported from MS Project Server. It has fields like -

Time Period
Resource Name (the 3 different charts)
Project Name
Project Sub Task
Planned Work
Actual Work

I'm trying to create 3 pivot pie charts from which I can then select the resource name, but as soon as I change the selection on the 2nd chart the first one also changes. Is there a way to only filter at the chart level or do I need to duplicate each pivot table for each chart?

Thanks,
BL