Been working with Pivot tables for a while now, and one of the huge things I miss is the ability of selecting whether the values should be displayed as Columns vs Rows, something that you have in simple spreadsheet programs. This has proven useful when you want to show the same metric by different aggregations for example, so that they can see Total vs Avg vs Median.

Example:

Too wide and hard to follow

More compact and easier to read when values are displayed as rows.

This same functionality would solve some complex dashboarding issues in which you have to transpose Megatables to get a similar behavior, while still allowing for good drill down functionality.