Can you set order in Pivot Table Drop Down box?

  • Thread starter Thread starter Morocco_Mole
  • Start date Start date
M

Morocco_Mole

Hi,

I made a pivot table for my group to use in a product mapping tool.

The first column has the precursor products while the other column
tell the replacement product. This question only involves th
precursor products column.

The problem is that the drop down box places the precursor product i
alphabetical order while I need it to be in another order; basicall
the order that they are used to seeing now (major products first).

Ideal:
Major Product 1
Major Product 2
Major Product 3
Auxilary Product 1
Auxilary Product 2
Auxilary Product 3
(list much longer, short list for illustrative purposes)

But the pivot table places
Auxilary Product 1
Auxilary Product 2
Auxilary Product 3
Major Product 1
Major Product 2
Major Product 3

I supposed I can tell them to deal with it being alphabetized but I'
trying to make the transition to this tool painless for them.

Thanks in advance
 
Create a custom list with your precursor products in the correct order:

Type the list on the worksheet
Select the list
Choose Tools>Options
Select the Custom List tab
Click the Import button
Click OK

Create your pivot table, and the products should be sorted in the custom
order.
 
Back
Top