Column for the opposite of what i have selected

[Tamstar]

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

[CELAMBARASAN]

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],', ')

[Tamstar]

Thank you Celambarasan that worked perfectly.  Really appreciated 🙂