Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table sorting | Charts and Charting in Excel | |||
pivot table sorting | Excel Discussion (Misc queries) | |||
Sorting a Pivot Table | Excel Worksheet Functions | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
Pivot Table Sorting | Excel Worksheet Functions |