Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Programming in VB
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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Programming in VB
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Programming in VB
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. -- Regards, Tom Ogilvy "Sugith Kumar" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Programming | Excel Discussion (Misc queries) | |||
Or Excel Programming | Excel Worksheet Functions | |||
excel programming | Charts and Charting in Excel | |||
Excel/VBA programming | Excel Discussion (Misc queries) | |||
Excel Programming | New Users to Excel |