How to limit Nationality in report?

Sep 23, 2020 8:55AM

Summary

Multiple nationalities for some employees - I only want the the main or primary nationality

Hi,

I've attached the XML - can anyone modify the report so that it only shows 1 nationality? (some employees have 2/3 nationalities

which is creating duplicate lines in the report rendering it useless).

As a side note, Is a BI Publisher the only way to build a report that could have Nationality 1,2,3 as separate columns?

Thanks,

Andrew

20B