Pivot Table Question
 

I created a pivot table with more than one feilds dropped into 'row
feild' (1st and 2nd field below). Is there any way to not display the
total (row) but still display the second field's (column) values. When
I try to hide
ABC Total below it also hides A and B under 2nd Feild. See example
below.

1st Feild 2nd Field 1st column 2nd column 3rd column
ABC A 2.023186 60.103887 4.451046
B 40.995111 7.996889
ABC Total 2.023186 101.098998 12.447935


Thanks,
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=505024

Pivot Table Question
 

You can double-click the field button for the first field, and for
Subtotals, select None.

sa02000 wrote:
I created a pivot table with more than one feilds dropped into 'row
feild' (1st and 2nd field below). Is there any way to not display the
total (row) but still display the second field's (column) values. When
I try to hide
ABC Total below it also hides A and B under 2nd Feild. See example
below.

1st Feild 2nd Field 1st column 2nd column 3rd column
ABC A 2.023186 60.103887 4.451046
B 40.995111 7.996889
ABC Total 2.023186 101.098998 12.447935


Thanks,
Jay




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Pivot Table Question
 

Debra, Thanks.
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=505024