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
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