In a crosstab that uses an IBM® Cognos® TM1® data source, you can apply a
filter to values to display only the top or bottom results.
You
can apply a top or bottom filter in the following ways.
- Show only the top results to quickly determine the highest values
in your data. For example, you want to know which sales representative
contributed the greatest amount to yearly sales, so you apply a top
percent filter.
- Show only the bottom results to quickly determine the lowest values
in your data. For example, you want to know which employees spent
the fewest dollars on travel, so you apply a bottom rows filter.
Top and bottom filters are not available when you use an IBM Cognos BI
data source.
Procedure
- Right-click a column header cell then click .
- Select a sort option and enter a value.
- For Top rows and Bottom rows,
the value represents the number of rows to display.
- For Top percent and Bottom percent,
the value represents a percentage of the sum of all values. For example,
you can type 10 to display the customers who contribute to the top
10% of revenue.
- For Sum of top rows and Sum
of bottom rows, the value represents the sum of the results
you want to display. For example, you can type 10000000 to display
the customers who contribute to the first 10 million dollars of revenue.
Results
In the overview area, a symbol appears in the columns box
to indicate a top or bottom filter is applied. To remove the filter,
right-click the header cell then click .