| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotals in Pivot Tables
I have a pivot table with two row fields. Excel does a nice job of formatting
the table automatically, but it includes a total line when the first field changes value. I don't want this subtotal line. Is there any way to get rid of it? XL XP on Windows XP -- Regards, Fred |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals in Pivot Tables
Right-click on the outer field button
Choose Field Settings For Subtotals, choose None Click OK Fred Smith wrote: I have a pivot table with two row fields. Excel does a nice job of formatting the table automatically, but it includes a total line when the first field changes value. I don't want this subtotal line. Is there any way to get rid of it? XL XP on Windows XP -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals in Pivot Tables
Thanks so much, Debra. It's simple when you know how. At least I learned a lot
about Table Options, because I went through all of them before posting my query. -- Regards, Fred "Debra Dalgleish" wrote in message ... Right-click on the outer field button Choose Field Settings For Subtotals, choose None Click OK Fred Smith wrote: I have a pivot table with two row fields. Excel does a nice job of formatting the table automatically, but it includes a total line when the first field changes value. I don't want this subtotal line. Is there any way to get rid of it? XL XP on Windows XP -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Subtotals in Pivot Tables
Well, that sounds like a good thing!
Fred Smith wrote: Thanks so much, Debra. It's simple when you know how. At least I learned a lot about Table Options, because I went through all of them before posting my query. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Excel Pivot Tables - turn off subtotals | Excel Discussion (Misc queries) | |||
| add option in pivot tables to remove subtotals for fields | Excel Worksheet Functions | |||
| Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
| copying subtotals in Pivot tables | Excel Worksheet Functions | |||
| Pivot Tables- Total the Subtotals? | Excel Worksheet Functions | |||
Linear Mode
