To limit the data displayed on the report you can use a filter.

  • Select the Filter Data icon from the BI ribbon.

The Filter screen opens. You can enter a filter against the data displayed on either the Row or Column axis.

  • Select to Include or Exclude data based on the filter criteria that you enter.
  • Specify the Data that you want to Include/Exclude

The filter options available are:

Bottom (count)

The bottom number of rows specified, this could be used to show the 10 worse customers or products.

Top (%)

The rows or columns that comprise the top specified percentage of a column.

Bottom (%)

The rows or columns that comprise the bottom specified percentage of a column.

Top (sum)

The rows with the largest values that, when summed, comprise at least the value we specify.

Bottom (sum)

The rows with the smallest values that, when summed, comprise at least the value we specify.

Above

The rows above a value we specify.

Below

The rows below a value we specify.

Between

The rows between two values the we specify.

  • Specify the number or percentage that you want to display.
  • Finally choose the Measure/Value that you want to base your filter on.

You are able to add a second filter level i.e filter by X then by Y.

The ‘Supress Empty Rows/Columns’ option will remove any Rows/Columns that have no data. This means NULL values and not Zero values.

Advertisements