User manual
Table Of Contents
- Bento® 4
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book Library
- Migrating the iCal, iPhoto, and Address Book Libraries
- Using Collections
- Using Form View
- About Forms
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Showing and Hiding Forms
- Duplicating Forms
- Copying Forms
- Renaming Forms
- Locking and Unlocking Forms
- Adding Fields to a Form
- Tabbing Between Fields
- Moving Fields and Objects on Forms
- Resizing Fields and Objects
- Removing Fields from a Form
- Customizing Form Layouts
- Using Table View
- About Table View
- Selecting Records in Table View
- Creating Records in Table View
- Editing Records in Table View
- Duplicating Records in Table View
- Deleting Records in Table View
- Sorting Records
- Working with Fields and Columns in Table View
- Creating Fields in Table View
- Adding Fields in Table View
- Working with Media Fields in Table View
- Changing Options for a Field in Table View
- Completing Text Automatically as You Type
- Duplicating Fields
- Changing the Field Type
- Showing and Hiding Columns
- Deleting Fields in Table View
- Reordering Columns
- Resizing Columns
- Filling Fields Automatically
- Summarizing Column Data
- Using Grid View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Syncing
- Keyboard Shortcuts
- Reverting to a Previous Version of Bento
- Index
Chapter 7 Using Table View 67
Summarizing Column Data
The summary row provides an easy way to perform basic operations on the data in a
column and display the results. The summary row is located at the bottom of table
view and at the bottom of simple list fields and related data fields.
To show or hide the summary row, choose View > Show Summary Row or Hide
Summary Row. Or, click
.
Depending on the field type, the following summary functions are available.
You can use the Count function on any type of field. You can use the Sum, Average,
Minimum, and Maximum functions on fields of the following types: Number, Currency,
Duration, Rating, Automatic Counter, and Calculation (when the result is number,
currency, or duration). You can also use the Minimum and Maximum functions on
Date and Time fields.
Name Purpose
Sum Calculates the total of the values in the selected field
Count Reports the number of items that have an entry in the selected field
Average Reports the average of the values in the selected field
Minimum Reports the lowest value of the values in the selected field
Maximum Reports the highest value of the values in the selected field