A sort direction can be set for each column in a pivot table. https://help.libreoffice.org/6.2/en-US/text/scalc/01/12090106.html I am looking for the support of the possibility to sort data fields (which contain computed values) before contents from leading columns. https://en.wikipedia.org/wiki/Order_by
Moving to NEW
Drag both from "Available Fields" to "Row fields". The upper one groups the records on first level and the second one on second level. The sort order of the second level sorts only inside the group build from the first level. Please describe in more detail what do you are missing.