pivot table sorting

[robert]

I want to rearrange my columns in a pivot table.
does anyone know how to do this?

thanks
robert

 

[Toby Erkson]

You can manually drag the selected item to its new position. Also, you can
right click on an item in the column you want to change and select Field
Settings..., click the Advanced button, then make a selection from the
available radio buttons (like Ascending), then OK and OK.

 

[robert]

Beautiful thanks toby

You can manually drag the selected item to its new position. Also, you can
right click on an item in the column you want to change and select Field
Settings..., click the Advanced button, then make a selection from the
available radio buttons (like Ascending), then OK and OK.