Pivot Table switch values to show as columns or rows

marcel_luthi
marcel_luthi Coach
edited September 6 in Charting Ideas

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.

14
14 votes

In Review · Last Updated

Thanks for sharing your idea! We're currently reviewing it for future enhancements. Stay tuned for updates! 👍

Comments