Row limit

Limit the number of rows to be displayed in the object.

The rows to be displayed are the first ones, following the Rows sort order. The remaining rows are aggregated under the Others row.

For advanced rows limit options, see Advanced row filter.

Parameters

• Number of rows: Set the row limit value.

• Show others: Specifies if others row should be displayed and how it should be calculated.

Table with a Row limit equal to five.

Applies to

Table, Cross Table, Column Chart, Bar Chart, Line Chart, Area Chart, Pie Chart, Cross Column Chart, Cross Bar Chart, Cross Line Chart, Cross Area Chart, Combo (Filter)