Forum Discussion
Filter
Performance is best if you do this task in the query editor:
Start in your sales table and merge it with the table containing the IDs for EDU and MIL on Offer Id. Expand the result on one field only: Portal.
This will allocate EDU and MIL to the matching items and leave null for all others. Then replace null by the name you want this group to be named.
Kind of off topic, but an easier way to solve huge IF statements is with a SWITCH statement. Then you don't have to worry about so many parentheses. Your IF statement would like this:
=
SWITCH (
TRUE (),
[ID] = xxx, "Group 1",
[ID] = yyy, "Group 2",
[ID] = zzz, "Group 2",
"Group Other"
)Performance is best if you do this task in the query editor:
Start in your sales table and merge it with the table containing the IDs for EDU and MIL on Offer Id. Expand the result on one field only: Portal.
This will allocate EDU and MIL to the matching items and leave null for all others. Then replace null by the name you want this group to be named.
Thank you all!! That was exactly what I was trying to do! and it worked!
