Pivot table - sorting

[Adam]

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("Account number").AutoSort
xlDescending, "Sum of Paid fare"

Thanks!