Pivot Table

[LadyRave]

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:


[TABLE="width: 400"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]Self-Assessment Status[/TD]
[TD="align: center"][/TD]
[TD="align: center"]CAR Status[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Orange[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]ON-TIME[/TD]
[TD="align: center"]LATE[/TD]
[TD="align: center"]ON-TIME[/TD]
[TD="align: center"]LATE[/TD]
[/TR]
[TR]
[TD="align: center"]Project 19[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Project 28[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]


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?