This is follows up an earlier post on a point system for youth wrestling results that I am working on for my site. Thanks to the gracious help of David A Coop on this great site, I was able to create a system which automatically assigns points to wrestlers for placing at a tournament, based on what their place was and how many wrestlers were in the weight class. However, now I need to create a pivot table, ranking the wrestlers by total points with their age division and weight class- i.e. I'd like to see the Top 25 wrestlers at 9-10 Rookie 55 lb. weight class, 9-10 Rookie 60 lb. weight class, 9-10 Rookie 65, and so forth. The wrestlers should be listed in order of points within each age and weight division. The posting of results is going to be an on-going process, so I need to design the pivot table in such that I can append the result and have it automatically update the Pivot Table.
I have attached the document as I have it currently. I know nothing of pivot tables, and have found the tutorials confusing to say the least. Thanks in advance for any assistance!
Bookmarks