User Guide
4 Choose the column whose values you want to use to create lter criteria.
5 Use the remaining controls to dene the column value for rows you want to show.
6 To use additional lter criteria, click the Add button (+) to dene each one you want
to add.
If you choose “is in the top n values” or “is in the bottom n values,” all values matching
the top or bottom n will be shown, which may be more than n.
Note: You can’t add any new rows to the table until you stop ltering rows. To stop
ltering rows in the table, deselect “Show rows that match the following” in the
Reorganize window.
Creating Table Categories
You can organize a table into categories. You can create categories by selecting
particular rows for a category, or you can set Numbers to create categories and
subcategories automatically using the value in one or more columns of the table
(category value columns). When you use category value columns, changing values
in them may cause rows to move into dierent categories.
Each category or subcategory is displayed with a category row above it. You click the
disclosure triangle near the left edge of the category row to view or hide (expand or
collapse) the category.
Category row for office furniture
Category row for patio furniture
Category row for library furniture
Category rows have special characteristics that help you manage your categories.
You can add new categories, remove categories, and perform other operations by Â
using the cell reference pop-up menu for a category row. Choosing Expand All or
Collapse All expands or collapses all categories at the level of the row from which
you chose the command.
Cell reference
pop-up menu for this
category row
66 Chapter 3 Using Tables