Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached a picture that explains the problem.
I use a P() set analysis expression for answering to a query that requires an intersection between two sets.
The count calculation is correct.
Problem: The list box shows all the values while I want to show only the selected values by the expression (in this case just one - the "id1").
(Actually, I solved the problem using the Aggr() ("Interceptor" in the picture) but I don't like it as the Aggr() is a very resource consuming)
How to solve in a way more elegant and efficient?
Thanks
If you want to use set analysis, then Aggr() might be the only solution... I can't think of a way to avoid the use of Aggr()