Pivot Tables (Sumif)

[donflak]

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

 

[krcowen]

Don

The pivot table is a really slick way to look at your data; but if one
of the pivot table fields (row, column, page) is not part of the data
you will have a problem. If you could add the necessary sumif formula
to the dataset you would probably find the pivot table was a good way
to get the view of your data that you want.

Does your data exist in a workbook or are you linked to an external
data source?

Ken

 

[donflak]

Don

The pivot table is a really slick way to look at your data; but if one
of the pivot table fields (row, column, page) is not part of the data
you will have a problem.  If you could add the necessary sumif formula
to the dataset you would probably find the pivot table was a good way
to get the view of your data that you want.

Does your data exist in a workbook or are you linked to an external
data source?

Ken









- Show quoted text -

It is imported into a workbook on a daily basis.