Formatting calculated totals in a Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My pivot table summarizes monetary values and totals these values with the
auto -generated column total and row total. I have formatted the data values
that are displayed but how can I apply the same formatting to the total
column and total row?

So my pivot table looks something like this (as in no dollar signs on the
totals)
Jan Feb Mar Total
categoryA $10 $14 $25 49
categoryB $15 $12 $18 45
Total 25 26 43 94

Anyone any ideas?
 
Actually finally sussed a solution myself...

It goes like this:

' Sets formatting for totals
xlApp.ActiveSheet.PivotTables("Values").PivotSelect("'Column
Grand Total'", Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataOnly)
xlApp.Selection.NumberFormatLocal = "$#,###,###,##0.00"

' Sets formatting for totals
xlApp.ActiveSheet.PivotTables("Values").PivotSelect("'Row Grand
Total'", Microsoft.Office.Interop.Excel.XlPTSelectionMode.xlDataOnly)
xlApp.Selection.NumberFormatLocal = "$#,###,###,##0.00"
 
Back
Top