Nifty.

Nifty.

Originally shared by Romain Vialard

You can now right-click on a specific number in your pivot table, select Show details and Google Sheets will automatically create a new sheet in your spreadsheet to display the data behind this number.

https://sites.google.com/site/scriptsexamples/home/announcements/google-sheets-new-pivot-table