ExcelBanter - Pivot Table Ascending Order of Row Field

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Ascending Order of Row Field (https://www.excelbanter.com/excel-discussion-misc-queries/41068-pivot-table-ascending-order-row-field.html)

Pivot Table Ascending Order of Row Field

I have a Pivot Table with the Row Field populated with Client codes (ABC).
When I manually set the Feild Settings of the Row Data to Ascending I get the
following order below. Note the first code is out of order. When I put it
in decsending order I get the reverse order with the code JFM last in order.
Whey is this?

JFM
AXD
DTK
EIL
EQZ
FLD
GAJ
GOM
HNI
HUN
HZT
MSH
PGU
QAG
RJE
RUM
SLJ
TAH
UIS
VGJ
VZH
WCY
WLO

Do you have a Custom list with JFM as one of the entries (ToolsOptions,
Custom Lists)?

ExcelMonkey wrote:
I have a Pivot Table with the Row Field populated with Client codes (ABC).
When I manually set the Feild Settings of the Row Data to Ascending I get the
following order below. Note the first code is out of order. When I put it
in decsending order I get the reverse order with the code JFM last in order.
Whey is this?

JFM
AXD
DTK
EIL
EQZ
FLD
GAJ
GOM
HNI
HUN
HZT
MSH
PGU
QAG
RJE
RUM
SLJ
TAH
UIS
VGJ
VZH
WCY
WLO

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html