8,981
edits
Changes
no edit summary
<languages/>
<translate>
<!--T:1-->
<!--T:2-->
The data displayed in the object can be different from the columns used to create the dataset. You can create a dynamic dataset that bring brings the ''top ten clients by gross sales'' value and see in the object which products these ''clients'' buy. The data of the dynamic dataset does not necessarily need to be explicitly shown in the object.
<!--T:3-->
* Reference (Grouped by): Set the ''Text'' or ''Date'' column that will be used to group the dataset;
* Sorted by: Set if the filter of the dataset will get the greater (Descending) or smaller (Ascending) results;
* Limited to: Set the amount a number of rows that the dataset will bring;* Show others: Set if the remaining rows (not contained in the dataset) will be agregated aggregated under an ''Others'' row.
<!--T:6-->
To facilitate it's its use, think about the parameters as a question:
<!--T:13-->
[[File:ARF_filtro1Filtro Avançado de linhas 1+en-US.png|link=PNG]]
<!--T:14-->
<!--T:15-->
[[File:ARF_ex1Filtro Avançado de linhas 2+en-US.png|link=PNG]]
<!--T:16-->
<!--T:19-->
[[File:ARF_filtro2Filtro Avançado de linhas 3+en-US.png|link=PNG]]
<!--T:20-->
<!--T:21-->
[[File:ARF_ex2Filtro Avançado de linhas 4+en-US.png|link=PNG]]
<!--T:22-->