Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table not in order - why?
I always assumed that a pivot table would keep things in
order if told to. But I am making a pivot table from some data that includes a plant code column. The data is sorted by plant code on one sheet (which shouldn't make any difference), and when I make the pivot table on a new sheet and drag the plant code to the 'Row Fields' area (one the left side), Excel puts a plant named 'MAR' at the beginning in front of 'BRO', 'CHA', etc. I have trimmed the values and know for sure that there are no spaces affecting the order. I have even gone into the PivotTable Field Advanced Options for that field and changed the 'AutoSort' from Manual to Ascending and it STILL doesn't put MAR in the correct spot. Any idea what is causing MAR to sort first? The entire list is: MAR BRO CHA FLR HILL LEC MAP MOEC NOES RAL RCK STGAR STHAR STMAR STNAR VIN WHOP WLM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table not in order - why?
The pivot table is looking at MAR to be an abbreviation
for March and therefore putting the date on top. To sort the way you want, try putting a space after the R. You would get the same reaction if you changed MAR to any other month (try DEC). -----Original Message----- I always assumed that a pivot table would keep things in order if told to. But I am making a pivot table from some data that includes a plant code column. The data is sorted by plant code on one sheet (which shouldn't make any difference), and when I make the pivot table on a new sheet and drag the plant code to the 'Row Fields' area (one the left side), Excel puts a plant named 'MAR' at the beginning in front of 'BRO', 'CHA', etc. I have trimmed the values and know for sure that there are no spaces affecting the order. I have even gone into the PivotTable Field Advanced Options for that field and changed the 'AutoSort' from Manual to Ascending and it STILL doesn't put MAR in the correct spot. Any idea what is causing MAR to sort first? The entire list is: MAR BRO CHA FLR HILL LEC MAP MOEC NOES RAL RCK STGAR STHAR STMAR STNAR VIN WHOP WLM . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table not in order - why?
How did you get that?!?!?! WOW! I'm impressed! I never
would have thought of that. You are good!! Norm -----Original Message----- The pivot table is looking at MAR to be an abbreviation for March and therefore putting the date on top. To sort the way you want, try putting a space after the R. You would get the same reaction if you changed MAR to any other month (try DEC). -----Original Message----- I always assumed that a pivot table would keep things in order if told to. But I am making a pivot table from some data that includes a plant code column. The data is sorted by plant code on one sheet (which shouldn't make any difference), and when I make the pivot table on a new sheet and drag the plant code to the 'Row Fields' area (one the left side), Excel puts a plant named 'MAR' at the beginning in front of 'BRO', 'CHA', etc. I have trimmed the values and know for sure that there are no spaces affecting the order. I have even gone into the PivotTable Field Advanced Options for that field and changed the 'AutoSort' from Manual to Ascending and it STILL doesn't put MAR in the correct spot. Any idea what is causing MAR to sort first? The entire list is: MAR BRO CHA FLR HILL LEC MAP MOEC NOES RAL RCK STGAR STHAR STMAR STNAR VIN WHOP WLM . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Pivot Table Column Order | Excel Discussion (Misc queries) | |||
Pivot table row field order | Excel Discussion (Misc queries) | |||
Pivot Table Order Not Functioning | Excel Discussion (Misc queries) | |||
Pivot Table out of order | Excel Discussion (Misc queries) |