|
Pivot table fields
Can I predetermine what order my pivot table fields results show up as
besides ascending or descending? Thanks! -- Jodie Gardner |
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 |
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 |
| All times are GMT +1. The time now is 02:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com