| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Hide Total Row without hidding corresponding row
I have a pivot table with several rows, one of which is 'Cycle Time'. I want
to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hide Total Row without hidding corresponding row
Right-click on the Cycle Time field button
Choose Field Settings Under Subtotals, choose None, and click OK Suzanne wrote: I have a pivot table with several rows, one of which is 'Cycle Time'. I want to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hide Total Row without hidding corresponding row
Thank you for responding. There's not a 'sub total' option in the Field
Settings window that displays when i right click on the field. The buttons are 'hide' 'number' 'options'. "Debra Dalgleish" wrote: Right-click on the Cycle Time field button Choose Field Settings Under Subtotals, choose None, and click OK Suzanne wrote: I have a pivot table with several rows, one of which is 'Cycle Time'. I want to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hide Total Row without hidding corresponding row
If it's a Data field, and your Data fields are listed in the Row area,
you can't control which Data fields are subtotaled, and which aren't. However, you could select that set of subtotals, and format them with white font and white fill, so the subtotals aren't visible. Suzanne wrote: Thank you for responding. There's not a 'sub total' option in the Field Settings window that displays when i right click on the field. The buttons are 'hide' 'number' 'options'. "Debra Dalgleish" wrote: Right-click on the Cycle Time field button Choose Field Settings Under Subtotals, choose None, and click OK Suzanne wrote: I have a pivot table with several rows, one of which is 'Cycle Time'. I want to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hide Total Row without hidding corresponding row
I'll try it, thank you Debra.
"Debra Dalgleish" wrote: If it's a Data field, and your Data fields are listed in the Row area, you can't control which Data fields are subtotaled, and which aren't. However, you could select that set of subtotals, and format them with white font and white fill, so the subtotals aren't visible. Suzanne wrote: Thank you for responding. There's not a 'sub total' option in the Field Settings window that displays when i right click on the field. The buttons are 'hide' 'number' 'options'. "Debra Dalgleish" wrote: Right-click on the Cycle Time field button Choose Field Settings Under Subtotals, choose None, and click OK Suzanne wrote: I have a pivot table with several rows, one of which is 'Cycle Time'. I want to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table - Hide Total Row without hidding corresponding row
You're welcome!
Suzanne wrote: I'll try it, thank you Debra. "Debra Dalgleish" wrote: If it's a Data field, and your Data fields are listed in the Row area, you can't control which Data fields are subtotaled, and which aren't. However, you could select that set of subtotals, and format them with white font and white fill, so the subtotals aren't visible. Suzanne wrote: Thank you for responding. There's not a 'sub total' option in the Field Settings window that displays when i right click on the field. The buttons are 'hide' 'number' 'options'. "Debra Dalgleish" wrote: Right-click on the Cycle Time field button Choose Field Settings Under Subtotals, choose None, and click OK Suzanne wrote: I have a pivot table with several rows, one of which is 'Cycle Time'. I want to show this row for each of the items in the table, but don't want it to appear as a total. When i try to hide it, the corresponding rows (of detail) in the table hide also. I want to see the rows in the table, but not in the totals. Any ideas please? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table, grand total no negatives | Excel Worksheet Functions | |||
| Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Size | Charts and Charting in Excel | |||
| Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
| Erroneous Grand Total of calculated fields in pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
