excelgraham
New Member
- Joined
- Oct 25, 2021
- Messages
- 1
- Office Version
- 2019
- Platform
- MacOS
Hey,
I am trying to create a pivot table that shows the revenue and the month over month percent change of revenue that is sorted by the largest amount of revenue to the smallest amount of revenue.
After using "Show Values as..." to calculate the difference from the previous month and attempt to sort by largest to smallest revenue, I get an error saying "AutoSort and AutoShow can't be used with custom calculations that use positional references. Do you want to turn off AutoSort/AutoShow?"
How can I sort by largest to smallest revenue of the current month while still showing the percent change of revenue from the previous month?
I am trying to create a pivot table that shows the revenue and the month over month percent change of revenue that is sorted by the largest amount of revenue to the smallest amount of revenue.
After using "Show Values as..." to calculate the difference from the previous month and attempt to sort by largest to smallest revenue, I get an error saying "AutoSort and AutoShow can't be used with custom calculations that use positional references. Do you want to turn off AutoSort/AutoShow?"
How can I sort by largest to smallest revenue of the current month while still showing the percent change of revenue from the previous month?