Pivot Table Question

S

sa02000

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
 
D

Debra Dalgleish

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

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

Top