Posted to microsoft.public.excel.programming

Paul Martin Paul Martin is offline

external usenet poster

Posts: 114

Sorty PivotTable by ColumnField totals

Hi all

Using VBA, I want to sort a pivot table by column fields totals
(descending). When I use PivotFields.AutoSort, it sorts by the field
names, not the totals. Any suggestions please?

Thanks in advance

Paul Martin
Melbourne, Australia

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
How do I sorty by addresses, ignoring number, using street name	pat	Excel Worksheet Functions	1	April 11th 08 03:32 PM
PivotTable Totals	Joey	Excel Discussion (Misc queries)	3	February 13th 08 01:34 AM
PivotTable Grand Totals By Item	TMore	Excel Discussion (Misc queries)	4	April 29th 06 04:48 PM
Syntax for referencing totals of grouped data in a pivottable	mbpcon	Excel Worksheet Functions	1	October 23rd 05 05:24 PM
About calling highest level in columnfield	Polly[_3_]	Excel Programming	0	May 22nd 04 05:04 AM

All times are GMT +1. The time now is 08:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us