Hello Everyone,

I don't often get to use pivot tables and have quite a large project to work
on.

My question is in regard to sorting items which are listed inside a field in
the PivotTable Field List. I have quite a few items inside a field called
LABEL and only need to display a few of them in my pivot table report. I
have selected the apporpriate items (all of them text), now I need to sort
these items but alphabetical sorting will not help. I see that there is a
"More Sort Options" when I click on the drop-down arrow next to my field name
(which happens to be called LABEL). When I click on this I get a SORT
window and the first option is "Manual (you can drag items to rearrange
them).

I cannot rearrange the items because when I click on one with the mouse and
attempt to move it nothing happens. There are no other ways that I can see
to physically move these items. Futher, HELP does not explain how to
physically move my text items, either. A web search brings up nothing - why
doesn't this work and why isn't this most helpful method explained better by
Microsoft?

You have no idea how irritating this is - I KNOW it's possible to move my
items within the field but can't seem to get any info on this option!

Can someone help me?

Thanks!!