Calculated Column in Pivot Table

[EdStockton]

Hello All,

I have a pivot table into which I would like to total certain columns. The pivot table is structured as follows:

This is what my pivot table looks like
	0000	0000 Total	0215	0215 Total	1001	1001 Total	Grand Total
	OPCP	CFP		OPCP	OPMA	CFP		BOND	OPCP	OPMA	CFP
111	10	12	22	4,502	7,649	20	12,171	5,600	982	1,365		7,947	20,140
112	33		33			8,703	8,703				9,876	9,876	18,612
121	4		4		9		9				764	764	777
124		17	17			8,734	8,734		342		12	354	9,105
126	300		300	30	6,738		6,768		583	7,234		7,817	14,885
126.1	(145)		(145)		(628)		(628)			(1,638)		(1,638)	(2,411)
126.2						(132)	(132)		(53)			(53)	(185)
128	900		900	536	725		1,261	230	1,325	982		2,537	4,698
128.1	(35)		(35)	(13)	(200)		(213)		(450)			(450)	(698)
129	20	95	115	90	142		232		36	245		281	628
142	1,200		1,200	1,184			1,184		3,425	2,200		5,625	8,009
143	65	963	1,028		584		584			5,632		5,632	7,244
143.1		(20)	(20)		(36)		(36)			(2,501)		(2,501)	(2,557)
144	793		793	737			737		2,374			2,374	3,904
	3,145	1,067	4,212	7,066	14,983	17,325	39,374	5,830	8,564	13,519	10,652	38,565	82,151
Here is what I would like to do with my pivot table
	0000	0000 Total	0215	0215 Total	1001	1001 Total	Grand Total
	OPCP	CFP		OPCP	OPMA	Subtotal	CFP		BOND	OPCP	OPMA	Subtotal	CFP
111	10	12	22	4,502	7,649	12,151	20	12,171	5,600	982	1,365	7,947		7,947	20,140
112	33		33			0	8,703	8,703				0	9,876	9,876	18,612
Subtotal	43	12	55	4,502	7,649	12,151	8,723	20,874	5,600	982	1,365	7,947	9,876	17,823	38,752
121	4		4		9	9		9				0	764	764	777
124		17	17			0	8,734	8,734		342		342	12	354	9,105
126	300		300	30	6,738	6,768		6,768		583	7,234	7,817		7,817	14,885
126.1	(145)		(145)		(628)	(628)		(628)			(1,638)	(1,638)		(1,638)	(2,411)
126.2						0	(132)	(132)		(53)		(53)		(53)	(185)
128	900		900	536	725	1,261		1,261	230	1,325	982	2,537		2,537	4,698
128.1	(35)		(35)	(13)	(200)	(213)		(213)		(450)		(450)		(450)	(698)
129	20	95	115	90	142	232		232		36	245	281		281	628
Subtotal	1,044	112	1,156	643	6,786	7,429	8,602	16,031	230	1,783	6,823	8,836	776	9,612	26,799
142	1,200		1,200	1,184		1,184		1,184		3,425	2,200	5,625		5,625	8,009
143	65	963	1,028		584	584		584			5,632	5,632		5,632	7,244
143.1		(20)	(20)		(36)	(36)		(36)			(2,501)	(2,501)		(2,501)	(2,557)
144	793		793	737		737		737		2,374		2,374		2,374	3,904
Subtotal	2,058	943	3,001	1,921	548	2,469	0	2,469	0	5,799	5,331	11,130	0	11,130	16,600
	3,145	1,067	4,212	7,066	14,983	22,049	17,325	39,374	5,830	8,564	13,519	27,913	10,652	38,565	82,151

<tbody>
</tbody>

Your help would be appreciated. The first layer of columnar data is referred to as ProgNum. The second layer of columnar data is the Program. The possible options for the Programs are BOND, OPCP, OPMA and CFP. I would like to get a subtotal column for the programs BOND, OPCP, and OPMA. These Programs may or may not all exist for each ProgNum.

Thank you, Ed Stockton