Thread: pivot tables
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary L Brown
 
Posts: n/a
Default pivot tables

Minerva,
If you want to hide an element in the field, on the right side of each
field is a drop-down that you can use to un-check a particular value.
If you want to hide the field itself, right-click on the field and select
HIDE.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Minerva" wrote:

Is there any way that I can hide one of the fields of the pivot?
Basically I have created a pivot with fields like Department, Level,
Location, # People... which is customized based on a particular Department
only, but i do not want to "show" the "Department" pivot field in the report.