Pivot Table and Chart using same Query/Slicers/Timeline but different groupings

[gplhl]

Hi All, can't seem to find a solution to my problem. I have written a query that returns data from a database that is viewed in a pivot table. I use timelines and slicers to change what I am looking at, this works fine for one table and chart. I want to create other tables and charts also linked to the same query using the same, timelines but different slicers and grouped differently. However when I create another pivot table, any changes in one change the other!

The query doesn't seem to be available as a source if I use the old method of ALT+D then P.

 

[Alex Blakenburg]

I don't know if you have resolved this or if this even helps, but a query returns a table in the spreadsheet and therefore you are better off if you use either of these 2 menu paths:
Table Design > Summarize with Pivot Table
OR Insert > PivotTable.