Using Calculated expression as a filter in Set Analysis
I am struggling in a problem with a slider and a variable.
I have to filter the data in the table based on a variable , it's working fine , but the user can hide\show the columns that I use to calculate this variable, when the columns are hided I only get wrong results or error.
I tried to use Aggr and Set Analysis , but I couldn't make it work out.
Has anyone seen anything like that? I attached the example.