| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table fields
Can I predetermine what order my pivot table fields results show up as
besides ascending or descending? Thanks! -- Jodie Gardner |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table fields
You can create a Custom List (ToolsOptions, Custom Lists tab)
When you add a field to the pivot table, and sort in ascending or descending order, the custom list takes precedence. jodieg wrote: Can I predetermine what order my pivot table fields results show up as besides ascending or descending? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table fields
That worked! Thanks so much!
-- Jodie Gardner "Debra Dalgleish" wrote: You can create a Custom List (ToolsOptions, Custom Lists tab) When you add a field to the pivot table, and sort in ascending or descending order, the custom list takes precedence. jodieg wrote: Can I predetermine what order my pivot table fields results show up as besides ascending or descending? Thanks! -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Calculation Fields | Excel Discussion (Misc queries) | |||
| Pivot Table - Compare 2 fields? | Excel Discussion (Misc queries) | |||
| number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
| Pivot table # of fields | Excel Discussion (Misc queries) | |||
| Pivot Table Fields | Excel Worksheet Functions | |||
Linear Mode
