GreyFox8991
New Member
- Joined
- Jul 20, 2022
- Messages
- 23
- Office Version
- 2016
- Platform
- Windows
Hello,
I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to accomplish this. I am attaching a screenshot to show a sample of what the data looks like. The highlighted items are the percents however i am only focusing on the negative values.
I would like to end result to be: Negative YoY percent values on top in this pivot.
I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to accomplish this. I am attaching a screenshot to show a sample of what the data looks like. The highlighted items are the percents however i am only focusing on the negative values.
I would like to end result to be: Negative YoY percent values on top in this pivot.