Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter based on the result of expression

Hello dear!

I am looking to apply a filter based on values ​​resulting from the following constant expression in a graph :

Sum ( { < Moment = {' Held '} >} [ Qt . BDA ] ) / Sum ( { < Moment = {' PLANNED '} >} AGGR ( distinct SUM ( DISTINCT [ Qt . BDA ] ) , Chv_Mom_Prod_Mês_Colab ) )

This expression will return percentages for each dimension. I would like to create a filter based on percentage , which , for example, by clicking the green button seep results that were > = 100 % ; clicking yellow values ​​between 80 % and 99 % and clicking the red values ​​below 80 % .

Sorry for my bad english and i thank the help.

1 Reply
MK_QSL
MVP
MVP

Provide sample data... You can create a List Box based on expression which will give you different % slots...