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
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.