OWC Help: How to Insert Multiple InsertTotal ?
Hi I'm using OWC10 and i'm trying to insert multiple InsertTotal for my chart but the problem is that it only display one (ex. "Sum of Book" for my example)but now the others (ex. "Sum of Pen" from my code) that i have inserted together. Is there something wrong with my code or i forgot to add some more command?
Set total1 = oView.AddTotal("Sum of Book", _
oView.FieldSets("Book").Fields(0), _
document.all.PIVOT.Constants.plFunctionSum)
Set total2 = oView.AddTotal("Sum of Pen", _
oView.FieldSets("Pen").Fields(0), _
document.all.PIVOT.Constants.plFunctionSum)
oView.DataAxis.InsertTotal total1
oView.DataAxis.InsertTotal total2
Thanks in Advance!
Andrew
|