Pivot Table Sorting

guciolino

New Member
Joined
Feb 10, 2017
Messages
8
I have a question about sorting in pivot tables. The pivot table shows the

Sum of ITEM_TOTAL_SALESum of TOTAL DISCOUNT AMOUNTSum of Gross Margin

<tbody>
</tbody>

in the left columns is the Customer Code and Customer Name

The table is sorted by ITEM_TOTAL_SALES with all SALES_REPS ( the filter in the left corner ).

When I set the filter just to Bob (in this example) then it is no longer sorted and mixed up.

Is there a way (settings?) to make sure that ITEM_TOTAL_SALES is still sorted also after changing the sales rep in the filter?

THANK YOU ALL :)
 
Last edited:

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,090,478
Messages
5,414,785
Members
403,544
Latest member
rabdorawsh

This Week's Hot Topics

Top