Thread
:
SORT List Items in Pivot field
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
external usenet poster
Posts: 2,979
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
Reply With Quote
Debra Dalgleish
View Public Profile
Find all posts by Debra Dalgleish