Deleting subtotals for rows only in Pivot Table

[tlrossi]

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.

Thanks for the help

 

[Norie]

Right click on the Count of GRADE % field and select Field Settings...

Then select None under Subtotals.

 

[tlrossi]

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]

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]

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]

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]

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]

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
	A	B	C	D	E	F	G	H	I	J	K
3	SumofSales	Year
4	Salesman	1995	1996	1997	1998	1999	2000	2001	2002	2003	GrandTotal
5	a	1,718		1,566		372	736	661	791		5,844
6	d	1,875	190	1,162		2,072	1,630		764	1,597	9,290
7	f	982	1,182	865	351	966	2,613	1,280	833	618	9,690
8	g	1,459	461	291	572	738	581	1,844	1,398	606	7,950
9	h	1,508	350		1,380		982				4,220
10	GrandTotal	7,542	2,183	3,884	2,303	4,148	6,542	3,785	3,786	2,821	36,994
Pivot 1