|
|
#1
10-15-2013, 11:09 PM
|
|||
|
|||
Calculated field in PivotTable not doing as expected
Please see attached file.
I have lots of projects. Each project has a due date and an actual end date. I have a calculated field which shows whether the projects ended before their due date (i.e. they met their deadline). For each end date, I want to summarise the number of projects that met their deadline. My calculated field does not work. Could you please explain how I can modify my calculated field to get the desired result (which I have shown together with the incorrect result). Thank you 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Can't figure out calculated field
|
56_kruiser | Excel | 2 | 12-02-2012 03:50 PM |
| PivotTable | ibrahimaa | Excel | 0 | 06-19-2012 10:11 AM |
| Excel Pivot Table Calculated Field | BertLady | Excel | 0 | 05-21-2012 10:51 AM |
|
Calculated Field is disabled
|
MariaAdc | Excel | 1 | 03-01-2011 02:44 AM |
| Using calculated field - WHY IS IT SO COMPLICATED? | Riorin | Word | 0 | 10-30-2009 12:20 PM |
Windows Vista 
Office 2010 32bit
Threaded Mode