Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
How can I show all field data in a pivot table, instead of blank | Excel Discussion (Misc queries) | |||
Order Data in Pivot Table Non ascending or Decending | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |