Sugith

On the Pivot Table, Double-click the field header to be
edited e.g The grey Qty field at the top of the table.

Choose Sum from the drop-down list.

Regards
Peter
-----Original Message-----
I have a code as follows in a VB Subroutine.

With .PivotFields("Next Quarter")
.Orientation =4
.Position = 7
End With

the problem is, the field "Next Quarter" is coming
as "Count of" field instead of "Sum of". So all the
values
in this field are distorted. How do I force this field
to "Sum of"? Any idea?

A quick reply is appreciable.

Thanks
Sugith

.