View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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