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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Pivot table 1
Pivot table report invalid 0
Pivot Table Help! 1
Pivot Tables in Excel 2007 vs 2003 1
Sorting pivot table by specific field (column) 1
Form Combo Box & Pivot table (Excel 2007) 3
Pivot table from dynamic refreshed pivot table 3
Turning Data into a Table 1

Back
Top