Pivot table sorting, should be easy I think

[mcarrington]

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]

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