98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Piviot Tables
Piviot Tables
Resolved · Medium Priority · Version 2007
Tue 7 Aug 2012, 14:55Delegate Tracy said...
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
Fri 10 Aug 2012, 09:59Trainer Paul said...
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
Thu 16 Aug 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Line breaks in a cellYou can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it. |
