Pivot Table to allow Sorting by Column vs. Grouping

marcel_luthi Coach
edited August 2023 in Other Ideas

We need a setting to switch whether columns should group the values (current behavior) or sort them when using pivot tables.

By default, pivot tables will group all your Values by the columns you select which is useful when you want to see how a specific group is performing on a linear succession, like:

But often you want to know how the values of a calculation compare across each column, so you can easily identify what does best where, like which one has the highest Conversion Rate.

I know this could be done if you build a separate Pivot Table for each metric, but since all these metrics are related to each other, showing them in a single card makes the most sense.

3 votes

Active · Last Updated