pivot table sorting

  • Thread starter Thread starter robert
  • Start date Start date
R

robert

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

thanks
robert
 
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.
 
Beautiful thanks toby
Toby Erkson said:
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.
Click to expand...
 
Back
Top