| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
New Member
Join Date: Jun 2011
Posts: 1
|
Hi
This is giving me a big headache!!! I have a spreadsheet which I have put into a Pivot table. The columns of data are: Engineer Date (1 - 31st May) Job type (can be the same type of job within the same date) (DE, RE, New, DE/RE) Date across the top of the PT, and job type down column A. I would like to count per job type per day per engineer, HOWEVER, for each job type per day I need to deduct the first two of its kind. i.e if 16 De's for 1st May, I need it to state 14. If 3 New then need it to state 1. Obviously in the pivot table I can just drage Job type into the Values area and change from sum to count but this does not deduct the first 2 jobs. what calculated field sum/equation do I need to deduct the first two jobs. Thank you very much. 
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot table, IF function, calculated item versus calculated field | NomadPurple | Microsoft Excel Misc | 1 | 9th Mar 2010 03:17 PM |
| Pivot Table - Add calculated field using field number (index) vs n | Preston Bandy | Microsoft Excel Programming | 0 | 7th Dec 2009 07:57 AM |
| Calculated Field and Calculated Item in Pivot Table | Fred Smith | Microsoft Excel Misc | 0 | 4th Mar 2007 08:15 PM |
| Pivot Table Formulas Calculated Item / Calculated Field | =?Utf-8?B?VmlrcmFtIERoZW1hcmU=?= | Microsoft Excel Programming | 2 | 10th Oct 2006 08:45 AM |
| pivot table formulas for calculated field or calculated item | =?Utf-8?B?Vmlja3k=?= | Microsoft Excel Misc | 3 | 6th Jun 2006 05:06 AM |
