Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to calculate total for a column with not all values filled
Hi,
I am trying to get a OWC pivot table running through a Web page. I am facing an issue while calculating total for one of the Fields. Not all the cell for this field will have values. I am using the following code to calculate the total and adding that field to the view. [code] Data as XML: <z:row Classification='Country' CurrentLevel='331' TargetLevel='361' Acct='9999AXH' Size='0.15' Return='0.26'/ ' add data axis oView.DataAxis.InsertFieldSet oView.FieldSets("Size") 'add total size column Set totalSize = oView.AddTotal("Size Total",oView.FieldSets("Size").Fields(0), c.plFunctionSum) oView.DataAxis.InsertTotal totalAvgSize [code] I am getting an error - <b"Function cannot be applied to the given field" </b. Appreciate your help in this. Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
How can I calculate total spend on items that have different values | Excel Worksheet Functions | |||
How do I compare two values to calculate a total? | Excel Worksheet Functions | |||
Hiding a total until all values are filled | New Users to Excel | |||
calculate which cells in column A will give me the total of column | Excel Worksheet Functions |