Hi,

What is the exact code which will give me Sum instead of Count for a
Pivot Field?

I have used following code but it gave me error

Sheets("Summary").PivotTables("PivotTable1").Pivot Fields("Duration").Orientation
= xlDataField

Sheets("Summary").PivotTables("PivotTable1").Pivot Fields("Duration").Function
= xlSum

I got the following error

Run-time error '1004'

Unable to set the Function property of the PivotField class


Can you help me?

Regards


--
hiunnati