| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted Total in Pivot Table row field
I have a pivot table with two row fields and one data field:
Row Field = Year Row Field = Quarter DataField = Average of Price The table creates a row total of the year field. I do not want this. I have turned off the Grand totals for the rows in the options but still get totals for each year. When I take the year out of the ro field and just use quarters, a row total is not calculated for th quarter. It only appears when I put in a superceding row field (year) I get: 2004 ------Q1-----$5.00 ------Q2-----$6.00 ------Q3-----$7.00 ------Q4-----$8.00 Total 2004-$6.50 But I want: 2004 ------Q1-----$5.00 ------Q2-----$6.00 ------Q3-----$7.00 ------Q4-----$8.00 How do I get rid of this total? Thank -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field Total in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Field using Grand Total | Excel Worksheet Functions | |||
| Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
| CUSTOM FIELD OR SUB TOTAL IN PIVOT TABLE | Excel Discussion (Misc queries) | |||
| Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
![ExcelMonkey[_101_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
