Sort Rows

For Cross tables you can choose which row you want to have sorted

If a different sorting is needed, then the table can be sorted in the same order as another table or ‘named range’ (Excel only).

Video: Sort in Same Order as...

Grid table: Read more in Sort Grid Table.