Piviot Tables

Resolved · Medium Priority · Version 2007

Tue 7 Aug 2012, 14:55 Delegate 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:59 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Line breaks in a cell

You 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.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips