Grouping Countries

[akpofureenughwu]

Good day everyone,

I am designing a report with about twenty countries of the World in it.

I need to place these countries into their respective continents so I can have a filter for it. (continent-filter)

Please find the picture for clarity.

Thanks in advance

[sunny_talwar · Accepted solution]

Add another table where you link each country to its Region/Continent

TableName:

LOAD * INLINE [

Region, Country

NA, USA

NA, Canada

APAC, India

APAC, Pakistan

...

];

[akpofureenughwu]

THanks Sunny

Perfectly Working!!!

[sunny_talwar]

Awesome