MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Change the Calculation in a Pivot Table


May 06, 2019 - by Bill Jelen

Change the Calculation in a Pivot Table. Photo Credit: NordWood Themes at Unsplash.com

Pivot tables offer a myriad of calculations in the Field Settings dialog box. Here is a faster way to change a calculation:

  1. Drag Revenue to the Values area twice.
  2. Double-click on the heading Sum of Revenue2. Excel opens the Value Field Settings dialog.

  1. Click on Show Values As and select % of Column Total from the dropdown.
  2. Type a new name in the Custom Name field, such as % of Total.
This pivot table has Revenue twice in the Values area. The second column of revenue is called Sum of Revenue2 in cell C3. Double-click that heading to open the Value Field Settings dialog. Type a custom name % of Total. On the Show Values As tab, choose % of Column Total

Thanks to Александр Воробьев for suggesting this tip.

Title Photo: NordWood Themes at Unsplash.com


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.