Advanced row filter

Creates a dinamic dataset that is used as a filter in the object.

Question: I want to filter the 10 greater clients by gross sales.

For basic row limits, see Row limit.

Parameters

• Ordered by: Set the Value column that will be used as the criterion for the filter;
• Grouped by: Set the Text or Date column that will be used to group the resultset;
• Sorted by: Set if the filter will get the greater (Descending) or smaller (Ascending) results;
• Limited to: Set the ammount of rows that the filter will bring;
• Show others: Set if the remaining rows (not filtered) will be agregated under an Others row.

Example

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)