Default Summary Function in Pivot Tables? (Excel 2k sr1)

[DMc]

Hi,
I'm trying to produce lots of graphs from a pivot table, using the sum summary function, but every time I change the data to graph, it defaults back to the count function.
Is there a way to say what function to use by default?

[RENE VG]

HI DAVID

If you record a macro to create your pivot tables (something like the first part of the coding), you can add the 2nd part of the coding which will always give you sum instead of count. The problem is that you want to a summary on the pivot table which is not a numeric field.

Sheets("DETAIL").Select
Range("FILTER_DATA").Select
ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
"DETAIL!FILTER_DATA", TableDestination:=Range("SUMMARY!A1"), TableName:="PivotTable1"
ActiveSheet.PivotTables("PivotTable1").DisplayErro rString = True
ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="MANUFACTURER"


With ActiveSheet.PivotTables("PivotTable1").PivotFields (PIVDATA)
.Orientation = xlDataField
.Name = "SUM OF " & PIVDATA
.Function = xlSum
End With

Hope this will help you.