Jun 09 2022 03:16 PM
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.
Jun 10 2022 05:23 AM
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.