Pivot Table Sums

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

Guest

When I create a pivot table with the wizard I click on the "options" box so that the columns and rows won't total, but this always happens anyway which makes for a lot of work to remove these. Thanks in advance for any help, Paul
 
What do you mean by that? In the option you can uncheck grand totals for
rows and columns,
are you saying you get that anyway?

--

Regards,

Peo Sjoblom

pas926 said:
When I create a pivot table with the wizard I click on the "options" box
Click to expand...
so that the columns and rows won't total, but this always happens anyway
which makes for a lot of work to remove these. Thanks in advance for any
help, Paul
 
Do you want to turn off the subtotals that appear for each row or column
heading? If so, you can use the following macro:

Sub NoRowAutomaticSubtotals()
'turns off Automatic subtotals in pivot table
Dim pt As PivotTable
Dim pf As PivotField
For Each pt In ActiveSheet.PivotTables
For Each pf In pt.RowFields
pf.Subtotals(1) = False
Next pf
Next pt
End Sub
 
You must log in or register to reply here.

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

Referencing a pivot tables Grand Totals Column 1
about pivot table 1
Pivot Table - 3
Pivot Table Calculated Field - Sum/count 1
Pivot Table Column Totals - XL2003 5
Pivot table filter list - listing irrelevant subcategorys 1
Grand Totals for Pivot Tables 4
Average of % in pivot table 1

Back
Top