Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Really hoping someone can help.
I am able to filter by certain areas and concatenate their Type and Value into a column as follows:-
=concat (distinct[Activity Service Area Type] & '- ' & [Activity Service Area Value],', ')
But what i cant work out is to show the negative of this in a new column (ie the remaining values that havnt been selected).
Can anyone help please
Thanks
Use Exclude (E(Field Name)) in set analysis
Assuming that Activity Service Area Type field is used for selections
=Concat (distinct {<[Activity Service Area Type]=E([Activity Service Area Type])>} [Activity Service Area Type] & '- ' & [Activity Service Area Value],', ')
Thank you Celambarasan that worked perfectly. Really appreciated 🙂