Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables (Sumif)
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables (Sumif)
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 On May 12, 3:24*pm, wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables (Sumif)
On May 12, 5:08*pm, wrote:
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 On May 12, 3:24*pm, wrote: 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- Hide quoted text - - Show quoted text - It is imported into a workbook on a daily basis. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
Pivot Tables -changing datasource for exsting Pivot Table | Setting up and Configuration of Excel | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |