Hi, I have data in Tables on separate Sheets in Numbers. I would like to create a Pivot Table using all those Sheets of Data.
In Excel, I would use Query to create a sheet that combines all the data and updates when the other Sheets are changed, and then create a Pivot Table from the combined sheet.
Thanks.
Essentially the same, but without the help of Query, which is not a supported feature in Numbers
Gather the information from the several tables onto a single table, then proceed to create the Pivot table from the combined sheet.
Regards,
Barry
Usually with formulas on the summary table that gather data from the data tables.
If you are familiar with scripting (I'm not.), it's also possible to use an AppleScript to gather data from one or more tables and place that data on the table from which the pivot table is created. Using a script would require the user triggering the script whenever an update is needed.
Regards,
Barry
How do you get the data all into one table, and it automatically update as more data is added to the other data sheets?
Creating Pivot Table using Data from Multiple Sheets/Tables
