Trying to create a variance column in pivot table - AutoSort and AutoShow causing issues?

I've previously made a pivot table that has: rows for customer, columns for year, revenue for values, and is sorted by revenue largest to smallest.

Previously, I was able to create another set of columns for variance (percentage), by dragging "revenue" into values, and changing the column to "Show Values as % Difference".

Now, I'm using a different dataset (also from Power Query), trying to do the same thing, but running into this problem:

I get an error message, "AutoSort and AutoShow can't be used with custom calculations that use positional references. Do you want to turn off AutoSort/AutoShow?" If I say yes, I can't sort anything (which is essential), if I say no, I can't calculate variance (also essential).

All the fields are the same, but I have a filter for different salespeople here (but it still doesn't work when I remove this filter.) I can't figure out why this is happening on this pivot table, when it worked perfectly before, any ideas or workarounds?