This is not consistent. Users can do it in Straight tables but not pivot tables. Users are having to export their reports that are designed as pivot tables to Excel and sort the results in Excel. Excel can pivot data and sort it on column values. If this is not possible then allowing users to sort the rendered results in the access point would be nice. Worth opening a case for this ?