Is it possible to override totalling function/values?

G

Greg Fricke

I have a pivot table I am generating programmatically. I have the
totalling information as part of my result set. I want to override
the totalling values with my result set's data.

I am able to grab the totalling rows/columns, but it is quite messy
depending on the possibility of subtotaling at many levels. I also am
unable to actually override the value, it does nothing.

Using VSTO:
var grandTotalRow =
pivotTable.DataBodyRange.Rows[pivotTable.DataBodyRange.Rows.Count];
grandTotalRow.Value2[1,1] = 666
but the value remains its' original value.

Is it possible either overwrite the value or the formula to use data
on another sheet/object?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top