| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot row order query
Hi All, I have a table of data, where column A contains the order and column B the actual data which should appear in on the row within the pivot table. What happens however is that the data in column B is sorted alphabetically within the pivot and not in the order on the base data. Can this be sorted using VBA? Many thanks Love Amy xx -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=518352 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot row order query
If you add the order field as the first row field, the column B items
should sort correctly. AmyTaylor wrote: Hi All, I have a table of data, where column A contains the order and column B the actual data which should appear in on the row within the pivot table. What happens however is that the data in column B is sorted alphabetically within the pivot and not in the order on the base data. Can this be sorted using VBA? Many thanks Love Amy xx -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot row order query
Debra, thanks so much for your reply, but I dont want the first column (coumn A) to be visible on the pivot table. If i follow your suggestion I have to have column A visible. Amy xx -- AmyTaylor ------------------------------------------------------------------------ AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970 View this thread: http://www.excelforum.com/showthread...hreadid=518352 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot row order query
You could create a custom list, and use that as the sort order:
In a cell on a blank worksheet, type your list, then select it Choose ToolsOptions Select the Custom Lists tab Click the Import button, click OK When you create a new pivot table, items should be in the order of the custom list. To sort the items in an existing pivot table, select the field button, and choose DataSort Click the Options button, and choose your custom list. AmyTaylor wrote: Debra, thanks so much for your reply, but I dont want the first column (coumn A) to be visible on the pivot table. If i follow your suggestion I have to have column A visible. -- 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 | |||
| Changing the order of fields in a query | Excel Discussion (Misc queries) | |||
| Microsoft Query - Change the order of the fields | Excel Discussion (Misc queries) | |||
| Fields change order from MS Query to Excel | Excel Discussion (Misc queries) | |||
| Change order of query updates | Excel Discussion (Misc queries) | |||
| Excel 03 DB query pulls data in wrong order, how to resolve? | Excel Discussion (Misc queries) | |||
![AmyTaylor[_44_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
