Although I have fought the urge, I have finally decided to venture
into the unchartered territory of pivot tables.

I have a large data set with a number of variables. I have determined
how to manipulate the data to produce the pivot table I need but there
is one qualifying factor that I cannot figure out.

I am trying to chart work hours and overtime hours by employee type
(Full Time, Part Time, Seasonal, etc.), employee department
classification (manufacturing, maintenanace, management, sales, etc.),
work location and Day of the week. All of this was fairly easy and
straight forward.

Now I want to add thresholds to include or exclude data. For
instance, I would like to see work hours for Part Time, Sales
Employees, in All work locations who worked more than 4 hours on any
single day.

How do I add the 4 hour qualifier. I could do it with a hard code
sumif formula on a separate worksheet but that kind of defeats the
purpose of the pivot table.

Your assistance is greatly appreciated.

Don