SORT List Items in Pivot field

  • Thread starter Thread starter Rui_Goncalves
  • Start date Start date
R

Rui_Goncalves

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting the pivot table field list 4
Pivot Item Displaying Incorrect Value? 1
Pivot Table Comparison 1
Calculated Item in Pivot table 1
Pivot Table Defaults 1
Pivot table field list missing 5
How to customize defaults in Pivot Table Values 1
Link Drop Down with Pivot Table 2

Back
Top