How to Remove an Access Pivot Table Total

Written by bradley james bryant
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Remove an Access Pivot Table Total
(Siri Stafford/Digital Vision/Getty Images)

Pivot tables are customised reports that allow data analysts to organise large amounts of data in seconds. Pivot tables exist is both spreadsheets and certain database applications such as MS Access. There are four different views in Access to view data in Access and one of them is pivot table view. This pivot table view has many of the same functions as the pivot table in MS Excel. Removing totals is an easy process.

Skill level:


  1. 1

    Open your pivot table. On the pivot table toolbar click "Create Calculated Detail Field."

  2. 2

    Locate the "AutoCalc" command on the toolbar. It should have a check box next to it.

  3. 3

    De-select "Autocalc" by clicking on the command. This will automatically remove totals from your calculation.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.