Excel Programming in VB

  • Thread starter Thread starter Peter Atherton
  • Start date Start date
P

Peter Atherton

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
 
Thanks for the quick reply. But here I need to control the
Excel sheet thru the VB Program. Because of the "Count of"
all the values in that field are appearing as 1. They are
actually holding diffrent values like 22.0, 25.2 etc

Thanks
Sugith
 
Turn on the macro recorder while you manually do what Peter suggested. That
should give you the attributes you need to work with to control you table.

If all your data is numeric, then excel will default to Sum of, but if there
is non-numeric or I think, even a blank field, it will default to Count of,
so you need to control it explicitly.
 
Back
Top