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:
Other People Are Reading
Open your pivot table. On the pivot table toolbar click "Create Calculated Detail Field."
Locate the "AutoCalc" command on the toolbar. It should have a check box next to it.
De-select "Autocalc" by clicking on the command. This will automatically remove totals from your calculation.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for