Google spreadsheets: Insert pivot table in the active sheet.
<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>