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

gplhl

Board Regular
Joined
Feb 23, 2002
Messages
149
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.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Alex Blakenburg

Well-known Member
Joined
Feb 23, 2021
Messages
616
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,175
Messages
5,640,607
Members
417,156
Latest member
Ciupanezul21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top