Pivot Table FILTERS sorting options - Excel 2013

P

phxfitness

New Member
Joined
Sep 22, 2017
Messages
1
Hello All,

I would like to ask for your assistance on how to sort the data in the FILTERS section of an Excel 2013 pivot table. It looks like it's sorting in the exact order it lives on the source file but I need it to sort differently in the pivot filter drop down window in order to make updates.

I would appreciate any assistance I could get on this.

Joe
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

FrumpyJones
  • Question
Is it possible to do a multiple Filter-sort?
Replies
3
Views
264
Kaper
Kaper
T
  • Solved
Error when sorting table - with exact same code that is working elsewhere
Replies
2
Views
127
TheRedCardinal
T
S
  • Question
Pivot table - calculate percentages with filters
Replies
0
Views
88
ShadowRider
S
M
  • Question
Excel pivot table query - retaining filters on pivot in absence of data
2
Replies
10
Views
1K
Alex Blakenburg
A
S
  • Solved
Sort Option For Filter Function?
Replies
5
Views
285
StephenCrump
S

Forum statistics

Threads
1,216,102
Messages
6,128,853
Members
449,472
Latest member
ebc9

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top