You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filter out multiple results

edited Oct 20, 2019 10:57AM in Reporting and Analytics for HCM 1 comment

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!