Is there a way to sort a pivot table based on the total column?
J jpdphd Nov 5, 2006 #2 Cindy, Sure. A picture is worth 1kwords, so look here. http://homepage.mac.com/jdilger/Excel/PivotSort.jpg To get the PivotField Table, double click on 'hi' Then, click on Advanced... to get Advanced Options Need more help? Just ask. jpdphd
Cindy, Sure. A picture is worth 1kwords, so look here. http://homepage.mac.com/jdilger/Excel/PivotSort.jpg To get the PivotField Table, double click on 'hi' Then, click on Advanced... to get Advanced Options Need more help? Just ask. jpdphd