Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
122
Views
Topic starter
So is it possible to use the result of a query as data(table) for a Pivot Table without any manual action.
So Without renaming a sheet bu typing the name or defining a table or ...
Thank You in Advance.
Posted : 19/02/2021 1:21 pm
Hi Marc,
Welcome to our forum!
In order to use the result of a query as the source of a PivotTable you must Close & Load to > PivotTable. This loads the data into the Pivot Cache and puts a PivotTable placeholder in the worksheet for you to build your PivotTable.
Another option is to Close & Load to > Connection Only & Data Model. This loads the data into Power Pivot for authoring PivotTables from there.
Mynda
Posted : 19/02/2021 8:19 pm
