Sorting by a specific PivotItem in a pivot table

jcsowder

New Member
Joined
Oct 6, 2009
Messages
5
I have been tasked to sort a pivot table according to a specific column / PivotItem in a pivot table. When I sort the field using PivotTable Field Advanced Options it sorts the pivottable by the grand totals of the PivotField containing the PivotItem. Is there a way to specify to sort the table only by particular Pivot Item?
For example. I have weekly numbers. Management would like to have the table show the rows in the pivot table sorted descending by the current's weeks counts.
 
Last edited:

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,108,974
Messages
5,525,993
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top