SORT List Items in Pivot field
Hello to all,
i have following problem. I have a pivot list which obtains data from an access database. The result is an excel report which states resources, Project, work Whenever a new resource is available the Excel Pivot does not sort the dropdown row field but just adds this new resource to the last position in the List box. The problem is that a quick search for a resource is therefore not possible. Is there any possibility to get this list box sorted without having to rebuild the whole Pivot. Regards Rui |
SORT List Items in Pivot field
Select the row field button, and on the PivotTable menu, choose
PivotTable Sort and Top 10 Select Ascending (or Descending) From the "Using Field" dropdown, choose the row field's name Click Ok wrote: Hello to all, i have following problem. I have a pivot list which obtains data from an access database. The result is an excel report which states resources, Project, work Whenever a new resource is available the Excel Pivot does not sort the dropdown row field but just adds this new resource to the last position in the List box. The problem is that a quick search for a resource is therefore not possible. Is there any possibility to get this list box sorted without having to rebuild the whole Pivot. Regards Rui -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 08:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com