Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an Excel spreadsheet with data in column 1 that is in an order which
only makes sense to me. I need to leave it in this order when I create the Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS. At this point it will sort A-Z or Z-A. I want it to stay just like it shows on my spreadsheet. I have checked the forum and have yet to find an answer. -- Lisa Fornal |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I could really use some help with this. The order I have my spreadsheet is
the order the data occurs, this is why I don't want A-Z or Z-A. Doing a custom sort to move each field would take way too much time. -- Lisa Fornal "Lisa F" wrote: I have an Excel spreadsheet with data in column 1 that is in an order which only makes sense to me. I need to leave it in this order when I create the Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS. At this point it will sort A-Z or Z-A. I want it to stay just like it shows on my spreadsheet. I have checked the forum and have yet to find an answer. -- Lisa Fornal |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Lisa
As far as I can see this is a bug, when there are numeric values in the field and I will report it. If you can change your data to text values, then choose PivotTable OptionsDisplaySort in Data Source order, then it will work. To convert your data quickly, select the columnData tabText to columnsNextNextColumn data formatTextFinish -- Regards Roger Govier "Lisa F" wrote in message ... I could really use some help with this. The order I have my spreadsheet is the order the data occurs, this is why I don't want A-Z or Z-A. Doing a custom sort to move each field would take way too much time. -- Lisa Fornal "Lisa F" wrote: I have an Excel spreadsheet with data in column 1 that is in an order which only makes sense to me. I need to leave it in this order when I create the Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS. At this point it will sort A-Z or Z-A. I want it to stay just like it shows on my spreadsheet. I have checked the forum and have yet to find an answer. -- Lisa Fornal |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Nothing changed. I did exactly what you suggested. Is there another possible
solution? -- Lisa Fornal "Roger Govier" wrote: Hi Lisa As far as I can see this is a bug, when there are numeric values in the field and I will report it. If you can change your data to text values, then choose PivotTable OptionsDisplaySort in Data Source order, then it will work. To convert your data quickly, select the columnData tabText to columnsNextNextColumn data formatTextFinish -- Regards Roger Govier "Lisa F" wrote in message ... I could really use some help with this. The order I have my spreadsheet is the order the data occurs, this is why I don't want A-Z or Z-A. Doing a custom sort to move each field would take way too much time. -- Lisa Fornal "Lisa F" wrote: I have an Excel spreadsheet with data in column 1 that is in an order which only makes sense to me. I need to leave it in this order when I create the Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS. At this point it will sort A-Z or Z-A. I want it to stay just like it shows on my spreadsheet. I have checked the forum and have yet to find an answer. -- Lisa Fornal |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Lisa
works fine for me If you want to send me a copy of your workbook I will see if I can see what is happening. to mail direct send to roger at technology4u dot co dot uk Change the at and dots to make a valid address -- Regards Roger Govier "Lisa F" wrote in message ... Nothing changed. I did exactly what you suggested. Is there another possible solution? -- Lisa Fornal "Roger Govier" wrote: Hi Lisa As far as I can see this is a bug, when there are numeric values in the field and I will report it. If you can change your data to text values, then choose PivotTable OptionsDisplaySort in Data Source order, then it will work. To convert your data quickly, select the columnData tabText to columnsNextNextColumn data formatTextFinish -- Regards Roger Govier "Lisa F" wrote in message ... I could really use some help with this. The order I have my spreadsheet is the order the data occurs, this is why I don't want A-Z or Z-A. Doing a custom sort to move each field would take way too much time. -- Lisa Fornal "Lisa F" wrote: I have an Excel spreadsheet with data in column 1 that is in an order which only makes sense to me. I need to leave it in this order when I create the Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS. At this point it will sort A-Z or Z-A. I want it to stay just like it shows on my spreadsheet. I have checked the forum and have yet to find an answer. -- Lisa Fornal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table Data Column Sort Excel 2007 | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Excel 2002: How to sort row totals in Pivot Table ? | Excel Discussion (Misc queries) | |||
Excel 2002: Can I sort columns of the Pivot Table ? | Excel Discussion (Misc queries) |