Prev: SUMIF/AND combination?
Next: Convert From Comment to Cell Content
From: StillLearning on 19 Mar 2010 08:32
I have a set of payroll data that I need to put into a pivot table, do some
calculations, and filter but I can't figure it out. Here is what I have:
Name Date Hours
John Doe 1/1/10 10
John Doe 1/2/10 8
Jane Doe 1/1/10 9
and so on
I want to summarize this data by week (can use the weeknum formula) and only
report people who work > a certain number of hours a week. So my pivot table
needs to look like this (assume I only want to see people working > 50 hours)

Name Week Number Total Hours(using pivot to calc)
John Doe 1 60
3 55
Total 195

Note that I want the total to be all the hours, not just the ones > 50.

Seems like I could do this if I could filter the value field.
Any help would be greatly appreciated.

From: Herbert Seidenberg on 19 Mar 2010 12:23
Excel 2007 PivotTable
Value Filter
http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_19_10.xlsx
Pdf preview:
http://www.mediafire.com/file/4m3olmqxmmi/03_19_10.pdf
 | 
Pages: 1
Prev: SUMIF/AND combination?
Next: Convert From Comment to Cell Content