title: Google spreadsheets: Insert pivot table in the active sheet.
body: <p>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.</p>
  
  <p>I am trying to convert an Excel dashboard into Google spreadsheet dashboard.</p>
  
  <p>Thanks</p>