Can a pivot table calculate two items under one category? Here's an example of what I want to do. I've provided a table of what I want the pivot table to look like when it's calculating the data. I don't know how to add/include actual excel cells into my message so I apologize about that.
Project 19 and 28 are both under the PM Orange. Project 19 is LATE under the 'Self-Assessment Status' Column and ON-TIME under the 'CAR Status' Column. Project 28 is ON-TIME under the 'Self-Assessment Status' Column and ON-TIME under the 'CAR Status' Column. The data in the pivot table should show the following results:
<tbody>
</tbody>
Grand Total of Self-Assessment Status:
ON-TIME - 1
LATE - 1
Grand Total of CAR Status:
ON-TIME - 1
LATE - 0
Is it possible to do this with a pivot table? I'm not sure if I have to create separate columns for ON-TIME or LATE. May someone please help?
Project 19 and 28 are both under the PM Orange. Project 19 is LATE under the 'Self-Assessment Status' Column and ON-TIME under the 'CAR Status' Column. Project 28 is ON-TIME under the 'Self-Assessment Status' Column and ON-TIME under the 'CAR Status' Column. The data in the pivot table should show the following results:
Self-Assessment Status | CAR Status | |||
Orange | ||||
ON-TIME | LATE | ON-TIME | LATE | |
Project 19 | 1 | 1 | ||
Project 28 | 1 | 1 |
<tbody>
</tbody>
Grand Total of Self-Assessment Status:
ON-TIME - 1
LATE - 1
Grand Total of CAR Status:
ON-TIME - 1
LATE - 0
Is it possible to do this with a pivot table? I'm not sure if I have to create separate columns for ON-TIME or LATE. May someone please help?