Pivot table- drill down

Hi!

I have a pivot table- data region, years and count of brands to be constructed.

I drill down to the details from the pivot table.

Is there a way I can open the drill down details in the same spreadsheet? and also once I have the data, is there a way I can delete it?

Appreciate any help! I have attached a sample spreadsheet.

Thanks,Pivot table - drill down.xlsx
Bala Daniel

Hi Bala,

you can select the existing sheet at the time of creating pivottable & slect the location to insert pivottable in the existing sheet.
press undo delete the sheet.

thanks

Hi thanks for the response!

Yes, that is correct- we can choose the location of the pivot tables. However, I was looking for the drill down details from the pivot table which opens in a different spreadsheet. For e.g. if I open B4, it opens in a new spreadsheet. I want to open the multiple cell options in the same spreadsheet as the pivot table and be able to delete it as well.

Hope I am clearer now.

Thanks!!