pivot tables

[Minerva]

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.

 

[Gary L Brown]

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,

 

[Minerva]

Thanks Gary

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
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.