Home

Pivot Table not sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-900007%22%20slang%3D%22en-US%22%3EPivot%20Table%20not%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900007%22%20slang%3D%22en-US%22%3E%3CP%3EI%20added%20some%20data%20to%20a%20pivot%20table%20and%20was%20trying%20to%20sort%20it%20from%20A-Z%2C%20the%20data%20sorts%20but%20for%20some%20reason%20the%20new%20data%20sorts%20beneath%20the%20original%20data%20and%20therefore%20won't%20mix%20so%20I%20can't%20group%20it%20appropriately.%20Any%20advice%20would%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-900007%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPIVOT%20TABLE%20PROBLEM%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESorting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-900080%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20Table%20not%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-900080%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422250%22%20target%3D%22_blank%22%3E%40FRobinson25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20depends.%20You%20may%20have%20numbers%20as%20numbers%20and%20'numbers'%20as%20texts.%20You%20may%20have%20dashes%20within%20texts.%20Perhaps%20something%20else.%20Without%20sample%20it's%20hard%20to%20say.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
FRobinson25
Occasional Visitor

I added some data to a pivot table and was trying to sort it from A-Z, the data sorts but for some reason the new data sorts beneath the original data and therefore won't mix so I can't group it appropriately. Any advice would help.

1 Reply
Highlighted

@FRobinson25 

It depends. You may have numbers as numbers and 'numbers' as texts. You may have dashes within texts. Perhaps something else. Without sample it's hard to say.

Related Conversations
Counting Days
Tim Hunter in SQL Server on
2 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies