So I am collecting info for test scores and I put the names and info in the pivot table. Is there a way to do a custom sort in the drop field category so I can just show who scored above a certain score?
So I am collecting info for test scores and I put the names and info in the pivot table. Is there a way to do a custom sort in the drop field category so I can just show who scored above a certain score?
If each name has one row, then you can try this trick.
Select the pivot table header cells starting from cell just to the right of the pivot table headers (outside the pivot table) and then go to Data|Filter|Autofilter.
You should be able to custom filter your results.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
This is such a simple and useful trick!! I was just browsing this site, looking for a solution for my problem, and here it is!! Thank you NBVC!!
Last edited by NBVC; 09-08-2011 at 07:44 AM. Reason: corrected spelling of my username
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks