Pivot Table subtotals using calculated dimensions

[#1]

Dear All

I have checked quite a few feeds but can't find exactly what I'm looking for.

I have a pivot table and I have calculated dimensions to create  subtotals for the selected records

The calculated dimension do what I need but I would like to remove the extra columns and just display the subtotals, is this possible?

in the example below it's the first 2 columns...i;ve messed up the data so total won't be correct in the sample..

.

=   Left(CostCode, 1) = 'Y'	=(CostCode =   'YBED')	Cost Centre	FORECAST 2013	BUDGET 2013	ACTUAL 2012	ACTUAL 2013	% Diff Vs Budget	% Diff Vs Last   Year
0	0	Cambridge	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	London	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	Language Centre	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	TTC Homerton	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	Delta/OnLine	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	MISSING	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
0	0	Total	£600.00	£600.00	£600.00	£600.00	0.00%	-0.12%
0	Total		£1,100.00	£1,100.00	£1,100.00	£1,100.00	0.00%	-0.12%
-1	0	YL Ardingly	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Bloxham	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Bowles	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Christmas Course	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Closed Groups	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Cobham	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Grosvenor Hall	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Leys	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL St Albans	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	YL Wellington	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	0	Total	£1,000.00	£1,000.00	£1,000.00	£1,000.00	0.00%	-0.12%
-1	-1	YL Bedgebury	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	-1	Total	£100.00	£100.00	£100.00	£100.00	0.00%	-0.12%
-1	Total		£600.00	£600.00	£600.00	£600.00	0.00%	-0.12%
Total			£600.00	£600.00	£600.00	£600.00	0.00%	-0.12%