Filter out multiple results
Summary
Nationality field - can I rank it?Content
Hi,
I have a report that I am using for Brexit. I'm now under pressure to try and make it slicker. I'm wondering if anyone can help (?), as I'm nowhere skilled enough to get to grips with it by just playing around - ANY words of wisdom would be massively appreciated (even if it's just to say that it cannot be done!),
When it comes to Nationality, some colleagues have just one, but a significant number have two, even three! I work in a business with c.175k employees. I have used a CASE WHEN to get them in to three groups - UK, EEA, International, however for those with multiple nationalities that span across groups (let's say UK and Italian), I get multiple rows for that colleague number, one UK and one EEA. I appreciate that is the right output. However, if I then tell you that I'm only interested in their UK status how can I get it to suppress and