Pivot tables provide an option to sort by row only. It would be great to be able to sort by column, or even better, allow the user to click which column to sort by, like a table. A typical use case could include several rows of sales people and then a column of sales revenue or volume. You cannot sort by a revenue of volume column, only by the main column which would be the user in this example.
Thank you for sharing your feature request! I’ve shared your request with the Product team for consideration.