# Pivot grand totals grouped by kind of value

#### futureexcelpro

##### New Member
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

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### RoryA

##### MrExcel MVP, Moderator
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

##### New Member
Thank you very much for your help, that worked!

Replies
1
Views
168
Replies
1
Views
277
Replies
2
Views
440
Replies
0
Views
114
Replies
0
Views
61

1,186,112
Messages
5,955,912
Members
438,225
Latest member
rsur

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back