Google spreadsheets: how to a insert pivot table in the active sheet?

Question

I'm trying to add a pivot table in the same sheet in which I have charts and other analysis,but when I try to add a pivot table it creates a new sheet.

I am trying to convert an Excel dashboard into Google spreadsheet dashboard.

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. If you want to, you can then delete the pivot table sheet.