Sorting on both Columns and Rows when using pivot tables
I'm encountering an issue when trying to sort on both columns and rows in a pivot table.
I want my columns to be sorted in date order, left to right - oldest to newest.
I want my rows to be sorted in alphabetical order, top to bottom - A to Z.
It seems to only apply the first sort in the list and ignore the other.
Is there something I am missing, or some kind of workaround I can use?