This seems like it should be easy, but it's not. I have a pivot table
with data like I have below. I want to sort the TICKER column on 2006
total (a subtotal) and not Grand Total , but my only options seem to be
sorting the tickers alphabetically or by grand total, not by 2006 total.
I want to keep the 2005 and 2004 data in the table. Any ideas?
-Megan

2006
TICKER Mar-06 Feb-06 Jan-06 2006Tot 2005 2004 GrandTot
QWE 1,815 4,407 993 7,215 10,762 1,035 19,012
GFD 1,434 2,428 634 4,496 6,727 11,223
XFG 200 1,089 680 1,969 5,115 740 7,824
NBV 315 760 50 1,125 5,299 115 6,539
WFF 775 125 877 1,777 3,025 4,802
KUY 290 60 350 2,289 1,000 3,639
IYT 690 305 938 1,933 6,804 1,530 10,267
FGH 760 740 575 2,075 6,083 8,158
VMB 460 130 590 6,399 720 7,709
CVB 841 174 485 1,500 4,670 6,170
NHG 366 500 84 950 4,607 335 5,892
KJH 710 360 510 1,580 3,979 286 5,845
HFG 2,680 198 605 3,483 2,087 5,570
ZSD 625 1,082 1,707 2,670 4,377
BFD 177 65 400 642 2,221 225 3,088
ADS 280 125 465 870 1,789 2,659
NGF 156 328 435 919 696 1,615
LIU 450 330 250 1,030 470 1,500


--
mcarrington
------------------------------------------------------------------------
mcarrington's Profile: http://www.excelforum.com/member.php...o&userid=21641
View this thread: http://www.excelforum.com/showthread...hreadid=555651

If you select a cell in the 2006Total column, and click the A-Z or Z-A
button on the Excel toolbar, it should sort by that column.

mcarrington wrote:
This seems like it should be easy, but it's not. I have a pivot table
with data like I have below. I want to sort the TICKER column on 2006
total (a subtotal) and not Grand Total , but my only options seem to be
sorting the tickers alphabetically or by grand total, not by 2006 total.
I want to keep the 2005 and 2004 data in the table. Any ideas?
-Megan

2006
TICKER Mar-06 Feb-06 Jan-06 2006Tot 2005 2004 GrandTot
QWE 1,815 4,407 993 7,215 10,762 1,035 19,012
GFD 1,434 2,428 634 4,496 6,727 11,223
XFG 200 1,089 680 1,969 5,115 740 7,824
NBV 315 760 50 1,125 5,299 115 6,539
WFF 775 125 877 1,777 3,025 4,802
KUY 290 60 350 2,289 1,000 3,639
IYT 690 305 938 1,933 6,804 1,530 10,267
FGH 760 740 575 2,075 6,083 8,158
VMB 460 130 590 6,399 720 7,709
CVB 841 174 485 1,500 4,670 6,170
NHG 366 500 84 950 4,607 335 5,892
KJH 710 360 510 1,580 3,979 286 5,845
HFG 2,680 198 605 3,483 2,087 5,570
ZSD 625 1,082 1,707 2,670 4,377
BFD 177 65 400 642 2,221 225 3,088
ADS 280 125 465 870 1,789 2,659
NGF 156 328 435 919 696 1,615
LIU 450 330 250 1,030 470 1,500




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html