Pivot table sorting, should be easy I think
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 |
Pivot table sorting, should be easy I think
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 |
All times are GMT +1. The time now is 03:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com