Sort Data Items in Pivot Table

C

Carolina

I generated a PIVOT TABLE from a master file and I want to sort ONLY AUG07
column in DESCENDING order....can this be done?

TREND REGION Jun-07 Jul-07 Aug-07
# Calls
AAA 23 24 26
BBB 25 45 50
CCC 57 90 84
DDD 16 20 22

Thanks a million!
 
D

Debra Dalgleish

You should be able to select a cell in the Aug-07 column and click the
A-Z button on the toolbar.
That would sort the table by the values in that column

However, you can't sort just the values in that column, without
affecting the other columns.
 
C

Carolina

Worked perfectly. But only on that one chunk of information. How do automate
to do this all throuhout the entire column and pivot table?

Carolina
 
C

Carolina

The link http://blogs.msdn.com/excel/archive/2005/12/20/506172.aspx addresses
the inmediate concern...thanks! Yet I am curious about what is says about the
"PivotTable AutoSort functionality"...how do I know if I have it? I don't
know where to look for it. I want it to auto sort the entire column on that
pivot table not just that one chuck of information. I have different type of
trends and if I have to sort manually every section if can become tedious.
Can you give me additional insight into this?

Thanks for your time!
Carolina
 
D

Debra Dalgleish

If you're using Excel 2003, when you sort one chunk, all the other
chunks are sorted in the same order. So, if CCC is the highest amount
under # of Calls, it will appear first in all the other categories, even
if it's the lowest amount in that category.

This is changed in Excel 2007, and the values sort as expected in all
chunks.
 
C

Carolina

I see what you said about the 2003 version. It happened the way you described
it.

If I understand correctly the 2007 will sort all chunks at the SAME time (in
descending order if that is what I selected) but each chuck INDEPENDENTLY
from the other chucks? I am trying to see if I should get the 2007 version
for this reason. It boils down to:
I have 8 different chunks of information. But each chunk has to be sorted in
descending order. They will all vary according to the data. Can this be done
with the 2007 version?

Have a wonderful day and once again, thank you for your time.
Carolina
 
C

Carolina

Thanks Debra! I am now requesting my IT dept to get me the 2007 version since
they have it available. You were right...the information was on ryguy's
link...now that I read it carefully I understand it!
Thanks for your time!

Carolina
 

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

Extract data in rows (with line breaks) to form a table 0
In Pivot table sort 1
When building a chart Dates are been included that are not in thedate range 2
Help on Pivot Table 2
Pivot Table Summary Error? 6
Sorting 2 data columns in Pivot Table 2
Pivot Table Calculations 0
Pivot table 3

Top