3,050
edits
Changes
Created page with "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..."
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)]]
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)]]