Sort in Pivot Table

D

deacs

I have a Pivot Table with 3 columns of data. Column A has the Dept
Number, Column B has the Dept Description, and Column C has $ amounts
associated with the Dept in Columns A and B. Is it possible to sort
the data in this Pivot Table by the $ amounts in Column C? If so, I
would greatly appreciate your help in doing this?

In the mean time, I've just copied and pasted special the data in the
chart into a different sheet and performed the sort there.

Thanks in advance!
 
D

Debra Dalgleish

You can double-click the Dept Description button, and click Advanced.
For AutoSort options, select Ascending, then click OK, click OK.
However, the amounts will be sorted within the Departments, not overall.
 

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

SUMIF WITH OR 6
Pivot Tables 1
Pivot Table Set Up 2
Pivot Table Sort 1
Printing pages from Pivot Tables automatically 4
Sort in a Pivot Table 1
Pivot Table Data Column Sort Excel 2007 1
Pivot Table- Column 2 sort 3

Top