MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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
Assuming you have time in the values area; add it as a row field - make it the 1st one i.e. one the left and then sort by that.
I think
Right click on the time column, go to Sort and it will show:
Sort Smallest to Largest
Sort Largest to Smallest
-------------------------
More Sort Options
Click on "More sort options" and then choose "Smallest to Largest" under "Sort Options".
Under "summary" it will tell you that it will
"sort Team by Sum of Finish Time in Ascending order"
It's easy to run into problems with times. Especially, as I found on one occasion, if you need to use negative times (e.g. under/over target).
(there is a solution, btw)
I'll have a quick play with this one.
make it the 1st one i.e. one the left and then sort by that.
thats it 🙂
it does it automatically. I had team, then time...
cheers
bails had the right answer though.