wakefield101
New Member
- Joined
- Jan 4, 2014
- Messages
- 31
I am trying to create a "ITEM" formula for my pivot table. Does anyone know if it is possible to reference a cell that is not included within the pivot table?
Here is my formula that I am trying to create but I am having problems. Excel won't let me use this equation. Does anyone have any suggestions?
My formula that I am trying to incorporate:
IF(C21=1, 'Project Type' [Contracted] - ( 'Project Type' [Standard Activities] + 'Project Type'[Projects]),'Project Type'[Contracted] / ('Project Type'[Standard Activities] + 'Project Type'[Projects]))
Here is my formula that I am trying to create but I am having problems. Excel won't let me use this equation. Does anyone have any suggestions?
My formula that I am trying to incorporate:
IF(C21=1, 'Project Type' [Contracted] - ( 'Project Type' [Standard Activities] + 'Project Type'[Projects]),'Project Type'[Contracted] / ('Project Type'[Standard Activities] + 'Project Type'[Projects]))
| Excel Workbook | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | |||
| 19 | FEB-2016 | FEB-2016 | MAR-2016 | MAR-2016 | APR-2016 | APR-2016 | MAY-2016 | |||
| 20 | * | Reserved | Actuals | Reserved | Actuals | Reserved | Actuals | Reserved | ||
| 21 | Row Labels | Sum of Reserved mo01 | Sum of Actuals mo01 | Sum of Reserved mo02 | Sum of Actuals mo02 | Sum of Reserved mo03 | Sum of Actuals mo03 | Sum of Reserved mo04 | ||
| 22 | Projects | -51 | -56 | -50 | -50 | -49 | -39 | -50 | ||
| 23 | Contracted | 65 | 0 | 63 | 0 | 61 | 0 | 61 | ||
| 24 | Standard Activities | -4 | -12 | -13 | -14 | -14 | -11 | -15 | ||
| 25 | (blank) | * | * | * | * | * | * | * | ||
| 26 | Availability | 120 | 68 | 126 | 64 | 124 | 51 | 126 | ||
| 27 | * | * | * | * | * | * | * | * | ||
Capacity Plan Dashboard | ||||||||||
