Sort Pivot Table

Hi, is there an option to sort pivot tables on the summary column? On the screenshot below, we have the option to sort on the row values only, it would make more sense (for us at least) to sort the tables on values in the row summary.

Other nice to haves:

  1. Have an export button to allow getting the data out
  2. Limit (pagination) option

Additionally, in this image, the cases column counts how many cases each row has but the summary column just reports the column count (months in this example so always going to be 12). Shouldn’t it count the values instead?

Example: 1 + 10 + 10 + 20 = 41 but the pivot shows 4

1 Like

Has anyone managed to find a way around this yet? Its unusable for us at the moment and we have loads of pivots currently created with external queries.

On the example above, sorting by highest earners to lowest is really key

:crossed_fingers: