It would be great if clicking on the count, sum, etc in a cell in the pivot table would open a list view of the items making up that number. E.g. if I create a pivot on Ideas, with "product name" for the rows, and a count of Idea names in the cells, then clicking on the count of ideas would bring up a list of just the Ideas making up that count. (The equivalent of double-clicking in an Excel pivot table). There is no hyperlink on the cells at all at the moment.
I'd +1 this 100 times if I could! Taking it one step further, it would be nice to associate a specific list report to be displayed when you click on the pivot table cell value.
This is a very generic use case when comes to reporting.
This would be a great extension of the pivot report