Help with YTD Sales Summary

[RubiksCuber]

Ok so here's the skinny. I have a large number of sales agents that I am required to manually track sales for over the next few months. As the sales get made, by week - i am throwing them in this spreadsheet. I want the spreadsheet to rank them by units sold largest to smallest - by week - and I also want to see the YTD performance ranked the same way. I have played with the pivot chart wizard and i just can't get it to sort it the way I want and the online tutorials aren't really helping me get there...anyone have any suggestions?