Excel 2019: Change the Calculation in a Pivot Table
May 06, 2019 - by Bill Jelen
Pivot tables offer a myriad of calculations in the Field Settings dialog box. Here is a faster way to change a calculation:
- Drag Revenue to the Values area twice.
- Double-click on the heading Sum of Revenue2. Excel opens the Value Field Settings dialog.
- Click on Show Values As and select % of Column Total from the dropdown.
- Type a new name in the Custom Name field, such as % of Total.
Title Photo: NordWood Themes at Unsplash.com