Google spreadsheets: Insert pivot table in the active sheet.

google-sheets pivot-table
S.aad picture S.aad · May 12, 2016 · Viewed 14k times · Source

My question is pretty much stated in the title. I have been trying to add a pivot table in the same sheet in which i have charts and other analysis done but when i try to add a pivot table it create a new sheet.

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

Thanks

Answer

Ed Nelson picture Ed Nelson · May 12, 2016

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.

Related questions

Google Sheets Pivot Table Not Updating

I have a google app script which submits info to an organized sheet and would like to create a pivot table with the all information in the sheet. I can do this, but whenever I submit a new row of …

Read More
How do you create a "reverse pivot" in Google Sheets?

I am trying to produce a "reverse pivot" function. I have searched long and hard for such a function, but cannot find one that is already out there. I have a summary table with anywhere up to 20 columns and hundreds …

Read More
How to highlight cell if value duplicate in same column for google spreadsheet?

I am looking for formula for google spreadsheet highlight cell if value duplicate in same column can anyone please assist me for this query?

Read More