Help!
I’m running my first TT on Sunday, a team TT to make it slightly more complicated, and I’m trying to create a pivot table to easily show the winners in each category.
I have a master data sheet, where i have team, finish time, and cat. and I have created a pivot table which simply filters finish times on cat.
So, if I want to see all Senior Finishers, I filter on senior, and it shows everyones times who are marked as seniors. So Far so good, but I can’t sort those times to show the times from fastest to slowest. all Excel help says use sort A to Z, but this isn’t working on the time field.
any thoughts on how to easily sort a Pivot table?
thanks
Steve