I cannot use CASE cause the user might just select 1 or more payment terms also - its just that they wont select ones from US and Global together
1 person found this helpful
Why don't you make a second column prompt where you add the CASE WHEN to produce the 2 kind of terms (US & Global) ?
Then using the "limited by" you auto-filter the real list of payment terms based on the first selection and this is to answer your requirement to select all US or all Global with just 1 click.
You user want to select just 1 given term? Just ignore the first field of your prompt with the groups and select directly the required one in the second field.
Yes, Thank You this is definitely a good work around for me.
I added a new column and used the other to restrict the data..
I will keep this thread open to see if others have any other solution...
so I guess I cant do this in one single prompt ? is that it ?