Accounts that don't contain a Contract Type

[SandsFoy]

Hi,

Hope I'm asking this in the right place!

I'm using Web Intelligence Rich Client. I have lots of account number that can have many Contract types assigned to it. I want to list all the account that DONT have "With Maintenace" logged against it (but could have various others).

I have tried using "Query Filters" but can't find way, as if I choose "not in list" I get that account listed anyway with the other contract types.

If you could point me in the right direction that would be great.

Thanks.

 

[sandy666]

maybe

#"Filtered Rows" = Table.SelectRows(Source, each not Text.Contains([Contract types], "With Maintenace"))