I have sales data in a pvot table, columns Year/Month and in rows Customers.
I want to sort the customers by the highest sales dollars specific to each
year and not as combined. At present Pivot table only gives data in
descending order total sales dollars added for Year 1 and 2. Is it possible?