Pivot grand totals grouped by kind of value

[futureexcelpro]

Hi,

I have a problem with showing a customized grand totals in a pivot table.

I would want the pivot table to show me the periodic values for two kinds of value, both forecast and budget, as well as in the final columns to show the grand total for the both kind of value, forecast and budget. How pivot automatically does this is by calculating the grand total by combining forecast and budget values (in my example below the grand total would be 30, even though I would want 10 and 20).

If I would not want to look at the period values, pivot would automatically give me the totals in the form I would like (10 and 20). But the problem is, that I would like to have periodic values and their grand total value in the same table, and also divide the values to forecast and budget values, as shown in the table below.

Would you have any ideas to solve this problem? I really appreciate any help with this, thank you already in advance.

What I want:

P1		P2		P3		P4		Grand total
Forecast	Budget	Forecast	Budget	Forecast	Budget	Forecast	Budget	Forecast	Budget
2	4	3	6	4	5	1	5	10	20

What Pivot gives me right now:

P1		P2		P3		P4		Grand total
Forecast	Budget	Forecast	Budget	Forecast	Budget	Forecast	Budget
2	4	3	6	4	5	1	5	30

 

[RoryA]

Turn off the grand totals, then right click the field that is Budget/Forecast and choose Field Settings, then change the Subtotals setting to Custom... and Sum.

 

[futureexcelpro]

Thank you very much for your help, that worked!