I try to make a result list that counts sales amounts for locations selected in another list by zip code. the following is a simplified setup. That is why it might look a bit stupid--but it shows the problem I deal with.
If I select "22222" and "333333" it *should* return:
222222 100 333333 400
What it does return though is:
222222 0 333333 0
Obviously it that does not work, if more than one ZIP_all is selected from ZIP_codes. John wrote in another thread "A set is only build once per chart, not once per row". So I see that the set does not make sense if ZIP_all is a selection ov values.
But how else can I achieve this? How can I sum up values (one per line) that have an "condition".
I also tried
if(ZIP_ALL <= ZIP_code), sales_amount)
But that gives a "0" result as well. I just don't see to make a "list of seperate sums based on a condition".