Can you create a pivot table in the same sheet as the data its referencing?

Question

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.

Answer 1

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.