Sum Pivot Data

Select a pivot table and hit the key combo to change all the data fields to use the sum function.

When creating pivot tables, you may have noticed that any time you select all the rows to the bottom of the sheet as your source data, each time you add a data field to your pivot, it comes in using the “Count” function. Since most times we are typically trying to Sum, this utility will change all the fields you’ve previously added to use the “Sum” function.

Create your pivot table and add fields as normal. If you are planning to sum all the fields, wait until you have added all the desired fields, then hit the key combo.

Bam! You’re done. No one-by-one setup.

Leave a Reply

Your email address will not be published. Required fields are marked *