Filtro Avançado de linhas

Defina um conjunto de dados dinâmico que é usado como filtro para a data no objeto.

Os dados exibidos no objeto podem ser diferentes das colunas usadas para criar o conjunto de dados. Você pode criar um conjunto de dados dinâmico que exibe o valor do top 10 de clientes por vendas e ver no objeto quais produtos estes clientes compram. Os dados do conjunto de dados dinâmico não precisa necessariamente exibido no objeto.

Para limites básicos de linhas, veja Limite de Linhas.

Parameters

• Ordered by: Set the Value column that will be used to filter the results for the dataset;
• 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 of rows that the dataset will bring;
• Show others: Set if the remaining rows (not contained in the dataset) will be agregated under an Others row.

To facilitate it's use, think about the parameters as a question:

I want to filter the object data by the [Limited to] [Sorted by] [Grouped by] by [Ordered by].

or

I want to filter the object data by the [10] [greater] [clients] by [gross sales].

Example

1) Filter by and show the 10 smaller cities by net revenue:

Advanced row filter parameters:

Result:

In this case, the result dataset is being shown directly on the object.

2) Filter by the 10 greater cities by net revenue and show the product sales distribution is these cities:

Advanced row filter parameters:

Result:

In this case, the result dataset is being used to filter the product sales in these cities (10 greatest).

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.

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)