View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carolina Carolina is offline
external usenet poster
 
Posts: 41
Default Sort Data Items in Pivot Table

The link http://blogs.msdn.com/excel/archive/...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

"ryguy7272" wrote:

Some great resources he
http://www.contextures.com/xlPivot02.html

http://peltiertech.com/Excel/Pivots/pivottables.htm


This speaks specifically to your issue:
http://blogs.msdn.com/excel/archive/...20/506172.aspx

Keep at it! I'll bet anything it can be done! You make a few mistakes
along the way, but you will learn a lot in the process!!


Regards,
Ryan---

--
RyGuy


"Carolina" wrote:

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!