If you want to evaluate a different expression per dimension line, you would need a conditional that checks the dimension value and branch into the appropriate expression path, e.g. using a pick/match conditional combination.
If you want to evaluate a different expression per dimension line, you would need a conditional that checks the dimension value and branch into the appropriate expression path, e.g. using a pick/match conditional combination.
This expression is very costly to calculate, since QV needs to temporarily join all tables on the path between tables where the fields of your aggregation are located.
Then, the logic of the pick( N°Expresion, ...) would expect that you are listing (in your sample) 3 expressions, not only 1.
I assume you started with the first expression, then struggled with the syntax.
I found another way to get my result and almost I get it, just one expression gave me bad another result in comparison with the same expression but from the script :
