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