• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Take the Label "Sum of" Out of a Pivot Table

How to Take the Label "Sum of" Out of a Pivot Table

By: Shawn McClain
  • Share
  • Share on Facebook

When you add fields to the body of your Microsoft Excel 2010 PivotTables, Excel gives them a label of "Sum of X" or "Count of X," where X is the name of the field. Excel has to do this for the program to differentiate between the fields, but it can be frustrating if you are trying to customize the look of your table. You can remove the "Sum of" from the PivotTable, but if you try to leave the field name as a column header, Excel will give you an error, so you have to take an extra step to complete the process.

Step

Click on a cell in the PivotTable in the column from which you want to remove "Sum of."

Step

Click the "Options" tab on the toolbar, then click the "Field Settings" button under the "Active Field" area of the toolbar. A small window will pop up.

Step

Place your cursor in the "Custom Name" field and erase the "Sum of" from the name.

Video of the Day

Step

Move your cursor to the end of what is left and add a space to the name. This is because once you remove the "Sum of," the remaining name is that same as a recognized field in the field list, and if you try to make a second field, Excel will give you an error. The extra space lets Excel differentiate between the two names, but they will look the same to anyone who views your PivotTable.

Show Comments

Related Articles

How to Convert Excel Field to Boolean Type

How to Convert Excel Field to Boolean Type

Around The Home
Productivity
By: Ryan Menezes
How to Use Variables in Excel

How to Use Variables in Excel

Around The Home
Productivity
By: Ken Burnside
How to Import a CSV File to a vCard

How to Import a CSV File to a vCard

Around The Home
Productivity
By: Tammy Columbo
How to Calculate Incremental Growth in Excel

How to Calculate Incremental Growth in Excel

Around The Home
Productivity
By: Emily Ediger
How To Import a Calendar From Excel to Outlook

How To Import a Calendar From Excel to Outlook

Around The Home
Productivity
By: Brent Watkins
How to Make a 2 Column List in an Excel Spreadsheet

How to Make a 2 Column List in an Excel Spreadsheet

Around The Home
Productivity
By: Contributing Writer
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.