How can i add subtotals to the Pivot Table

S

sswift

I don't know if you'll know the answer to this, but whenever I add a
total this way, it always looks different than when I add the total by
clicking on the column in the Field List and adding it to the data area.

Also, I have a column named "DOLLARS" that will load in the data area
programatically(still looks bad from above), but another column name
"P2+" doesn't work. Is there some problem with have the "+" in the
column name? It works fine in SQL...it's just when I try to add it to
the Pivot table programatically that this happens.

Originally posted by Diego
If someone has the same problem, i resolved this way:

view.DataAxis.InsertTotal view.AddTotal("Totals", _
view.FieldSets("Value").Fields(0), _
Click to expand...
PivotTable1.Constants.plFunctionSum)
 

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

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Combine Sumifs with Subtotal 0
Power Pivot. Yikes. 0
Pivot Table cell values 1
Write back from pivot table 1
Write back from pivot table 0
Pivot table 0
multiple subtotals in pivot table 1

Top