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