Rearranging columns in a Pivot Table that have equations attached to them

Occasional Visitor


I had been asked to look at a general ledger and then sort it out so that we could look at the difference in spending for the same account over the three years. I did this all (the picture is a sample table I created that is similar just a lot less complex), and then I was asked if I could rearrange the columns so that they would display in order 2019, 2020, 2021, Diff of 2020 and 2019, Diff of 2021 and 2020, % Diff of 2020 and 2019, % Diff of 2021 and 2020. I am unable to just drag the 2021 over next to the 2020 I think because it will mess with the equation. How do I go about rearranging it in this order?

Thank You.

1 Reply


Workaround could be to to add data to data model creating PivotTable, create  required measures and show them in any desired order. That means don't add years into columns area.