filter sum superior than a value in a table

[Benoit]

Hello

I would like to filter in a visualization (a table) following the value present in this one (for example sum > 20)

Others filtres in my page can affect this table

When I put the filtrer at the table level (visualization), only the rows of the data table (on the right) with a value corresponding to the filtrer are kept

The value to filter is a sum, I would like that the filter is dynamic, and only follow the selectors of the page.

For example, if I select a week in this page (i have a calendar filter), i would like to find the values above 20 per week (even if this values are below 20 par day in the data table).

Is it possible without create new table ? 

Thanks

[Benoit]

Hello

I would like to filter in a visualization (a table) following the value present in this one (for example sum > 20)

Others filtres in my page can affect this table

When I put the filtrer at the table level (visualization), only the rows of the data table (on the right) with a value corresponding to the filtrer are kept

The value to filter is a sum, I would like that the filter is dynamic, and only follow the selectors of the page.

For example, if I select a week in this page (i have a calendar filter), i would like to find the values above 20 per week (even if this values are below 20 par day in the data table).

Is it possible without create new table ? 

Thanks

[v-jiascu-msft]

Hi @Benoit,

It could be easy. Please refer to the snapshot below. If this isn't what you want, please provide a dummy sample and the expected result.

Best Regards,

Dale

[Benoit]

Thank you.

But my request is a little different

I want to have a dynamic filter with a variable (greater than a value) which is not put in my visualisation.

If i add this filter in the visualisation filter, it is filtered with the values (greater than) in the table, but not the level of aggregat in my visualisation.

Do you think there are solutions ?

Benoit