You’re not locked into the PivotTable sorting options provided by Microsoft.  Excel lets you arrange a PivotTable into any order you like.

Right-click on a PivotTable column and choose Sort | More Sort Options | Manual.

How to Drag and Sort

It’s not obvious how to select an item (row or column) to move it.

Hover your mouse over the line between cells until you get the ‘Hollow +’ mouse pointer.

Windows 10 Spring 2018 Creators from people 'in the know'

A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.

Fully up-to-date with coverage of the 2018 Spring Creators edition 2016 major update of Windows 10.

This 800 page book shows you important features and details for all serious Windows 10 users.

Then click and drag to the new location.  A solid line is the guide to where the row/column will be placed.