View Single Post
  #1   Report Post  
ExcelMonkey
 
Posts: n/a
Default 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