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
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