I have a pivot table with Region as rows, Months as columns and volumes below it.
I added a measure which shows me if the value is above or below the previous month and now I would like to sort the pivot table by Region where the variance is the largest but ONLY for the current month.