Pivot table - sorting
Hi,
I am trying to sort data in a pivot table with more than one column fields (year 2008 and 2007) When I use the following code, it sorts by Paid fare but for total 2007 and 2008. How do I make VB sort the data by Paid fare in 2008 ? I cannot find it in the VB help. ActiveSheet.PivotTables("Second").PivotFields("Acc ount number").AutoSort xlDescending, "Sum of Paid fare" Thanks! |
All times are GMT +1. The time now is 01:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com