| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide and unhide sum in pivot table
It is possible to hide a sum of a certain value in a pivot table. Is there
also a way to show this sum again, or am I obliged to create the entire pivot table again? Thanks a lot. Pé |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hide and unhide sum in pivot table
I'm not sure what you mean, but if you remove a field from the data
area, you can drag it back in again, from the field list. Pé wrote: It is possible to hide a sum of a certain value in a pivot table. Is there also a way to show this sum again, or am I obliged to create the entire pivot table again? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hide and unhide sum in pivot table
I'm not removing any fields.
What I mean is that you can click with the right mouse button on a total you can hide this total...and now my question is if you can also show this total again? "Debra Dalgleish" wrote: I'm not sure what you mean, but if you remove a field from the data area, you can drag it back in again, from the field list. Pé wrote: It is possible to hide a sum of a certain value in a pivot table. Is there also a way to show this sum again, or am I obliged to create the entire pivot table again? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
hide and unhide sum in pivot table
When you hide a grand total you can show it again:
Right-click on a cell in the pivot table, and choose Table Options Add a check mark to Grand totals for columns and/or Grand totals for rows. Click OK Pé wrote: I'm not removing any fields. What I mean is that you can click with the right mouse button on a total you can hide this total...and now my question is if you can also show this total again? "Debra Dalgleish" wrote: I'm not sure what you mean, but if you remove a field from the data area, you can drag it back in again, from the field list. Pé wrote: It is possible to hide a sum of a certain value in a pivot table. Is there also a way to show this sum again, or am I obliged to create the entire pivot table again? -- 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 | |||
| Hide data in pivot table | Excel Discussion (Misc queries) | |||
| how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
| hide (blank) in pivot table | Excel Discussion (Misc queries) | |||
| How can I hide zero value lines in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table €“ Unhide field | Excel Discussion (Misc queries) | |||
Hybrid Mode
