Deleting subtotals for rows only in Pivot Table

tlrossi

New Member
Joined
Jan 21, 2005
Messages
6
ABR-109 ABR-109-801
Count of GRADE
Count of GRADE% 0.00%
ABR-109-802
Count of GRADE
Count of GRADE% 0.00%
ABR-109-803
Count of GRADE 4
Count of GRADE% 36.36%
ABR-109-804
Count of GRADE 3
Count of GRADE% 23.08%

ABR-109 Count of GRADE 7
ABR-109 Count of GRADE% 13.21%

I have sent a small sample of the Pivot Table. I need to delete the % subtotals for the individual rows and only show the total % subtotal listed at the bottom.
:rolleyes:
Thanks for the help
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
Right click on the Count of GRADE % field and select Field Settings...

Then select None under Subtotals.
 

tlrossi

New Member
Joined
Jan 21, 2005
Messages
6
Norie,

Doesn't work. If I right click in the row subtotal you get the "Summarize By:" option when you right click on field settings.

The only way to use the "none" option is if you right click in the subtotal at the bottom of the table, then all subtotals are deleted.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
What version of Excel are you using?

I'm using 2000 and can't seem to find a Summarize By option.

Perhaps I'm missing something.
 

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267

ADVERTISEMENT

Not the row subtotal, click on the field itself and then you get the subtotal options. The summarise by options you are looking at are in field settings for the numbers themselves.
 

tlrossi

New Member
Joined
Jan 21, 2005
Messages
6
Using Excel 2003.

But, to get the subtotals, I am using the "grade" field in the Data Field of the Pivot Table and asking it to show the % of the row total. But all I need is the % of the row total for the total at the bottom, not for each individual row.
 

tlrossi

New Member
Joined
Jan 21, 2005
Messages
6
Ken,

Don't get it! No matter where I click, other than the total at bottom, which I want to keep, I get the "summarize by".
 

KenWright

Active Member
Joined
Jan 14, 2005
Messages
267
As an example, in the following table you would right click on the a or d or f or g or h etc in cells A5:A9. The dialog box that would appear would give you the option to remove subtotals
Pivot Examplea.xls
ABCDEFGHIJK
3SumofSalesYear
4Salesman199519961997199819992000200120022003GrandTotal
5a1,7181,5663727366617915,844
6d1,8751901,1622,0721,6307641,5979,290
7f9821,1828653519662,6131,2808336189,690
8g1,4594612915727385811,8441,3986067,950
9h1,5083501,3809824,220
10GrandTotal7,5422,1833,8842,3034,1486,5423,7853,7862,82136,994
Pivot 1
 

Forum statistics

Threads
1,148,397
Messages
5,746,457
Members
424,020
Latest member
LongDoo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top