software

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 quot;showquot; the quot;Departmentquot; pivot field in the report.

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?''.quot;Minervaquot; wrote:

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

Thanks Gary

quot;Gary L Brownquot; wrote:

gt; Minerva,
gt; If you want to hide an element in the field, on the right side of each
gt; field is a drop-down that you can use to un-check a particular value.
gt; If you want to hide the field itself, right-click on the field and select
gt; HIDE.
gt; HTH,
gt; --
gt; Gary Brown
gt;
gt; If this post was helpful, please click the ''Yes'' button next to ''Was this
gt; Post Helpfull to you?''.
gt;
gt;
gt; quot;Minervaquot; wrote:
gt;
gt; gt; Is there any way that I can hide one of the fields of the pivot?
gt; gt; Basically I have created a pivot with fields like Department, Level,
gt; gt; Location, # People... which is customized based on a particular Department
gt; gt; only, but i do not want to quot;showquot; the quot;Departmentquot; pivot field in the report.