Sort pivot table by row totals

Hello, I would like to sort the pivot table with the rows with the highest row totals at the top. Is this possible in any way? This is a "simple" pivot table of 3 elements:

image

Hi @Tomas
That's currently not possible, but there's a request for it:
https://github.com/metabase/metabase/issues/16505 - upvote by clicking :+1: on the first post
You can sort by the metric in the Notebook editor:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#sorting-results

1 Like

There are two reasons why the directors of the business I work for want me to ditch Metabase and move back to Power BI.

  1. The font size is tiny on tables/pivot tables (maybe you can change this if you upgrade from Starter to Pro, but an extra £5000 a year is a lot to pay just to make the font bigger.)
  2. This topic - the fact that you cannot sort a pivot table, either in a fixed way via the report setup sort tool, or dynamically by clicking on the headings, like any other data tool.

It's been over a year since this topic was posted, how is this not fixed yet? I don't want to leave metabase, but if it doesn't change I will have no choice. It's a basic requirement.

Also, why can you export to excel from a pivot table in a report but not a pivot table in a dashboard?

I know it says to upvote on Github but I shouldn't have to sign up to this website and other websites to give feedback. Metabase if you are reading this, please do something about the above!