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:
Hi @Tomas
That's currently not possible, but there's a request for it:
https://github.com/metabase/metabase/issues/16505 - upvote by clicking 
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.
- 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.)
- 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!
1 Like
I just registered an account here to specifically let the team know how bllsht Metabase is.
There are so many things that are not available here compared to Power BI that I still do not know how you are not out of business yet.
You are lucky that our counterparty uses Metabase for some reason that only God knows, but I am doing all I can to move it to PowerBi
Get your sht together!