Filtering Rows

Filtering rows reduces the amount of data displayed in your table. For example, if you wish to see the population of Detroit and San Francisco under 18 years old, you would first find the table for the total population of these cities, and then create a row filter to remove all other age groups who are greater than 18 years old.

 

There are three ways you can filter data in tables; filter by data item, filter by control fields and filter by column.

 

 

Filter by Data Item

Filter by Control Fields Overlay

Filter by Dimension Column

Removing a Table Filter

 

 

Filter by Data Item

1.    From the table view click the modify table button located in the action menu above the table

2.    Click the filter rows icon button within a data value column (columns in the white area of the table), images\ebx_-1595834306.gif to filter rows based on the column’s value

3.    In the pop-up menu select a filter option from the filter list and enter a value in the value box(es)

 

images\ebx_-61616309.gif

 

4.    Click the OK button and the table will display rows that meet the filter requirement

 

 

Filter by Control Fields Overlay

1.    From the table view click the modify table button located in the action menu above the table.

2.    Click the filter rows button icon in the first column of the table images\ebx_-1595834306.gif.

3.    Click on the checkbox, images\ebx_880184381.gif next to the displayed filter option to select it.

 

images\ebx_124565170.gif

 

4.    Click the OK button and the table will display rows that meet the filter requirement

 

 

Filter by Dimension Column

 

1.    From the table view click the modify table button located in the action menu above the table

2.    Click the filter rows button icon within a dimension column (columns in the grey area of the table) , images\ebx_-1595834306.gif.

3.    Click on the checkbox, next to the displayed filter option to select it

images\ebx_923951372.gif

4.    Click the ok button and the table will display rows that meet the filter requirement

 

 

Removing a Table Filter

Click remove this filter, images\ebx_-505467006.gif from the filter overlay to remove the last added filter.

 

Note: Click the reset table button to restore the table to its original format

 

 

See Also

Tables_Overview

Hiding and Unhiding Rows and Columns

Reordering Table Columns

Sorting Rows

Transposing Table Rows and Columns

Tables Overview