cancel
Showing results for 
Search instead for 
Did you mean: 

Filter data by value or specific line - SAC

02-07-2024 11:57 AM
AngelMesp Explorer
977 views 2 comments
0 Likes
SAP Managed Tags
Subscribe

Helo experts,

I am trying to filter a table when the value of a measure is equal or higher than the value chosen by the user.

At the moment I can detect when it is higher or lower, but I cant filter by those lines and hide the ones that don't meet the criteria.

What I'm trying to do is after detecting which lines meet the criteria, save the ID of all the dimensions and filter the table, but this keeps showing me lines that I don't need.

What can I do?

Cheers

0 Likes

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor

@AngelMesp 

May be you can create a calculated dimension using value based dimension. Use measure value range to define the dimension values and then use this dimension to filter the table.

N1kh1l_0-1707308510048.png

 

Br.

Nikhil

AngelMesp
Explorer
0 Likes

Hello @N1kh1l

I tried to do but its a live model. I cant create a value based dimension measure.

Thanks for your help.