Sorting pivot tables by default?

[alexchumak]

I created a few simple 2-column pivot tables from a data sheet and in LibreOffice they seem to be sorted by the string value of the first column. In Excel they are all over the place.

Im looking for a way to pre-sort the pivot table by one of the columns.

Is it possible? Since i can only pre-sort the data sheet by one value and can't make it work for multiple pivot tables.

Any help would be appreciated.