Here is how you can re-arrange columns or rows in a PivotTable to get the look you want:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
Here are links to other posts about PivotTables:
By default, Excel will list the rows and columns of a PivotTable in alphabetical order, but that may not be in the order that you want. To change the order, just right-click on row or column heading and go down to “Move”. Here you will have the option of moving the row one place up or down, or moving it to the beginning or end of the list. It works the same for columns:
You will not be able to move it below or to the right of the Grand Total, those always need to be at the end.