8,981
edits
Changes
no edit summary
<translate>
<!--T:1-->
Define a dynamic dataset that is used as a '''filter''' for the data in the object.
<!--T:6-->
To facilitate its use, think about the parameters as a question:
<!--T:7-->
''I want to filter the object data by the '''[Limited to]''' '''[Sorted by]''' '''[Grouped by]''' by '''[Ordered by]'''.''
<!--T:10-->
'''Example'''
<!--T:11-->
1) Filter by and show the ''10 smaller cities'' by ''net revenue'':
<!--T:12-->
Advanced row filter parameters:
<!--T:13-->
[[File:Filtro Avançado de linhas 1+en-US.PNG]]
<!--T:14-->
Result:
<!--T:15-->
[[File:Filtro Avançado de linhas 2+en-US.PNG]]
<!--T:16-->
In this case, the result dataset is being shown directly on the object.
<!--T:17-->
2) Filter by the ''10 greater cities'' by ''net revenue'' and show the product sales distribution is these cities:
<!--T:18-->
Advanced row filter parameters:
<!--T:19-->
[[File:Filtro Avançado de linhas 3+en-US.PNG]]
<!--T:20-->
Result:
<!--T:21-->
[[File:Filtro Avançado de linhas 4+en-US.PNG]]
<!--T:22-->
In this case, the result dataset is being used to filter the product sales in these cities (10 greatest).
<!--T:23-->
The total amount of sales in the other cities are grouped under the ''Others'' rows. This row shows the other cities amount, not the other products.
<!--T:24-->
'''Applies to'''
<!--T:25-->
[[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)]]
</translate>