Posted to microsoft.public.excel.programming

Dennis Cheung[_2_] Dennis Cheung[_2_] is offline

external usenet poster

Posts: 17

sorting in pivot table

there are 2 fields in column area, they are class_name and product_name.
i need the sub-total of each class and sort by the total of products in
each category.
i tried to use the sort function in tools bar, it can sort only the category
which was selected. i needed to sort each class manully after refresh the
table.
can you help?

dennis

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting & pivot table	Eva	Excel Worksheet Functions	1	November 6th 09 12:24 AM
Pivot Table Sorting	Scott R	Excel Worksheet Functions	6	November 8th 07 01:22 AM
Pivot Table Sorting	jesterhs	Excel Discussion (Misc queries)	0	August 4th 05 06:38 PM
pivot table sorting	ushah	Excel Worksheet Functions	3	July 22nd 05 07:40 PM
Pivot Table sorting	TomHinkle	Excel Discussion (Misc queries)	5	June 2nd 05 09:14 PM

All times are GMT +1. The time now is 10:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us