Pivot Tables

Resolved · High Priority · Version 2010

Thu 30 Apr 2015, 15:37 Delegate David said...

David has attended:
No courses

Pivot Tables

How do you insert a formula within a Pivot table? For example, the pivot table has 3 columns:

- # of Employees
- Total Salaries
- Total Bonus

In this example, I need to insert a formula that calculates Bonus as a % of Salary: Total Bonus divided by Total Salaries

Thank you for your help.

Regards,
David

Fri 1 May 2015, 10:17 Trainer Richard said...

RE: Pivot Tables

Hi David

Thank you for using the forum to ask a question.

Click on your Pivot Table and then choose the Purple Tab on the Ribbon PivotTable Tools - Options

In the Calculations group click on the Field, Items & Sets. Then choose Calculated Field from the Drop down list.

This displays a calculation dialogue box
Call your Field "Bonus % Salary"
In the formula use the =
(Double Click) Total Bonus / (Double Click) Total Salaries

Click OK

This will now appear as a heading in the Field List and will display on your Pivot Table

Kind regards

Richard
Microsoft Office Specialist Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Paste with Live Preview in Excel 2010

Did you know you can preview what you are about to paste? Here's how to do it.

Copy what you are about to paste
Position the cursor where you want to paste
Right click to display the shortcut menu
Place the cursor over the Paste Options and this will give you a preview of the what you are about to paste.

View all Excel hints and tips