Multiple Pivot Table Combinations

[123CJA]

Hi,

I have a data set which includes a field for "Result", two options within this field are "Lost" & "Cancelled". There is another field "Closure Rationale" which contains options which can be common for both of these "Results".

I have grouped the "Closure Rationale" into "Cancelled W" or "Cancelled W/O" so I now have a sub-group "Closure Rationale2" however I cannot work out how to drill the data so I can show a single total for:

All "Lost" Business (including "Cancelled W"AND "Cancelled W/O")
All "Cancelled" Business excluding "Cancelled W"

In other words I need my pivot table to include both "Closure Rationale2" for "Lost" but only "Cancelled W" for Result of "Cancelled".

I know I can add a column on my data which would cover this however I am sure it must be possible within the pivot table.

Sample:
Result

	Closure Rationale
Cancelled	Contract Expired
Cancelled	Replaced by Another
Lost	Customer Merger / Acquisition / Liquidation
Cancelled	Customer Merger / Acquisition / Liquidation
Cancelled	Internal Portfolio Transfer

<colgroup><col><col></colgroup><tbody>
</tbody>

I hope this makes send and thank you in-advance for any help.

 

[123CJA]

I have taken this from my pivot table:
The TOTAL I have worked out myself however this is what I need to get too with a single cell!

Cancelled		Lost		TOTAL
Cancelled W/O	Cancelled W	Cancelled W/O	Cancelled W
$40.23	$409.83	$18.67	$3.66	$62.56

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>