How to Remove an Access Pivot Table Total
Pivot tables are customized reports that allow data analysts to organize 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.
Other People Are Reading
Instructions
-
-
1
Open your pivot table. On the pivot table toolbar click "Create Calculated Detail Field."
-
2
Locate the "AutoCalc" command on the toolbar. It should have a check box next to it.
-
-
3
De-select "Autocalc" by clicking on the command. This will automatically remove totals from your calculation.
-
1
References
- Photo Credit Siri Stafford/Digital Vision/Getty Images
