# Calculated field for Grand total in Pivot

#### nikkap25

##### New Member
[FONT=&quot]Hello Geniuses,[/FONT]
[FONT=&quot]I want to calculate % of room revenue from total revenue for 3 months in pivot table.[/FONT]
[FONT=&quot]Months Aug’16 Sep’16 Oct’16 YTD Total
ROOM REVENUE 94 96 94 284
Total Revenue 134 132 128 394[/FONT]

[FONT=&quot]% To Total Revenue 70% 72% 74% 216%[/FONT]
[FONT=&quot]Grand total of % To Total Revenue should be (284 / 394 = 72%), but here is showing 216%[/FONT]
[FONT=&quot]Thank you..
Nikunj[/FONT]

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Can you upload the pivot? I think its just selecting the wrong thing This should work. Im an accountant and use this regularly.

Create a calculated field with the formula ='Room Revenue' / 'Total Revenue'. This assumes that your data looks something like this below (Pivot table starts at A7).

Excel 2010
ABCD
1MonthRoom RevenueTotal Revenue% To Total Revenue
2Aug-169413470%
3Sep-169613272%
4Oct-169412874%
5
6
7Row LabelsSum of Room RevenueSum of Total RevenueCalculated YTD Total
8Aug-169413470%
9Sep-169613273%
10Oct-169412873%
11Grand Total28439472%
Sheet1

Replies
4
Views
1K
Replies
0
Views
289
Replies
1
Views
597
Replies
6
Views
601
Replies
0
Views
284

1,196,250
Messages
6,014,232
Members
441,808
Latest member
xplainer

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