Just one idea.
[Field A]+"_"+[Field B]
If Field B has more items than, Filed A, you can add Field B after added from Filed A.
Then put the filter in Filter shelf and select "True" only.
I don't think you can achieve this with filter action, BTW,
Filter_Combined_9.1.twbx 8.9 KB
Thank you very much for that Shin, your response was very helpful. Is there anyway however that I can also select "All" records as well as Multiple values, all in the one filter? Basically the same functionality as a Multi-value filter.
If you're on TXT/Excel, you could Pivot
both [Field A] and [Field B] into a single Dim.
This would make other things complicated, though.
Brilliant, that's exactly what I was after Shin, thank you so much for your help and prompt responses.
That's my pleasure, and one more thing.
Could you mark my answer as "Correct to show that this Q is answered.