Hi,
It think it would be awesome to have on click actions on values listed in a pivot table that shows a list of related records that is involved in the calculation of that value.
USE CASES - The following reports that are based on a timetable (monthly, weekly, Daily etc.):
-
Monthly expenditure report showing total amounts for each account (user wants to see what items are on the list that makes this value above/below budget)
-
Daily inventory report showing total amounts for each Warehouse item (user wants to see what transactions are involved when he/she sees big/small numbers)
Cheers!