Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot Table Question | Excel Discussion (Misc queries) | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |