# Pivot Table Calculations

#### Sunclipse

##### New Member
Is it possible to add a calculated formula that divides into a grand total given by the pivot table?

Ex:

I have the Revenue generated by each product in a list. Can I add a row that will show the percentage of total revenue and change accordingly as I pivot the table?

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
Right click on the data field and choose "Field Settings." Then click on the "Options" button to expand the dialog box. In the "Show data as" drop down box, choose "% of column" or "% of row" as appropriate. Note that you can also drag the same field into the data area twice, then have one column with the actual number and the other with the percent:
Book5
ABCDE
11
12Data
13ProductSumofRevenue2SumofRevenue
14a10010.00%
15b20020.00%
16c30030.00%
17d40040.00%
18GrandTotal1000100.00%
19
20
Sheet1

Hope this helps.

Replies
0
Views
110
Replies
0
Views
139
Replies
0
Views
172
Replies
8
Views
144
Replies
1
Views
727

1,219,811
Messages
6,150,362
Members
450,955
Latest member
rose8693

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