Is it possible to have a pivot table on the same sheet as the data it's referencing in a Google Sheet?
At the moment if I create a pivot table it always creates a new sheet.
Google-sheets – Can you create a pivot table in the same sheet as the data its referencing
google sheetspivot table
Related Solutions
I don't, except I suspect you are out of luck for the time being at least. However, even in Excel I have often found it as, or even more, useful to perform such grouping in the base data rather than in the pivot table. For me the summary provided by the table is often a prelude to drilling down for further detail and rather than end up then with many different extracts I find it much easier to filter the source data, which I have already formatted to suit me.
On that basis a hack of sorts may serve for you. Assuming data as in D:E in the image, I added three columns with formulae:
- A:
=year(D2) - B:
=month(D2) - C:
=weeknum(D2)
To reduce the need for recalculation I usually then convert the results to values.
ColumnsA:C can then be included in the pivot table and, unlike Grouping, the components of the date can be split between rows and columns in the pivot table:
No. A pivot table can be created from cells populated by a query.
Check your selection range (etc.).
Related Topic
- Google-sheets – Aggregate data with Sheets pivot table or graph
- Google Sheets – Custom Script in Pivot Table Value Formula Error
- Google-sheets – navigate from a pivot table back to the original database
- Google Sheets – Create Table Showing Difference Between Two Pivot Tables
- Google Sheets – Exclude Certain Data in a Pivot Table
- Google Sheets – Anchor Formula to Pivot Table Data
- Google Sheets – Use External Data Range for Pivot Table
Best Answer
Simply select the cells of the pivot table you want to copy and then copy and paste it in the spreadsheet or sheet where you want it (or select desired cells and use CTRL + X and then CTRL + V to move it). If you want to, you can then delete the pivot table sheet.