Tracy has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Word Intermediate course
PowerPoint Intermediate Advanced course
Word Advanced course
Project Management - Framework & Processes course
Piviot Tables
Hi, I have created a pivot table with very basic information, Supplier Name in the Row and Month in the column, totalling the amount spent with each supplier by month. All I need to do now is arrange by, amount speant, High to Low. Is there a way to do this when I put the piviot together or do I have to just highlight all the cells and sort by A to Z or in this case Hign to Low?? just wanted to see if there was an easy way that I am missing.
Many Thanks
Tracy
RE: Piviot Tables
Hi Tracy,
Sorry for the delay in getting back to you. You dont have to highlight all of the cells, just click into one cell and use the sort option and it will sort all high to low or low to high while keeping the information grouped by the supplier name.
This is the easiest way of sorting.
Thanks
Paul
