I need to be able to sort the pivot table not by the sellers name but in the sumof Revenue column
I also need to display the table in Month order, the query is sorted but when I put it in to the pivot it seems to loose the sort order for both month(Asc) and Revenue(desc). How do switch off this or reset the actual pivot table to sort correctly.
I have attached the file for example of my xls.
Please look at the Pivot 2 tab.