Hi,
We have one table format something like below:
| ID | Name | Region |
| 111 | ABC | America, London, Singapore |
| 222 | BCD | Dubai, Japan |
| 333 | CDE | Singapore |
In script have used sub field to make, Region to show only one country, something like below
| ID | Name | Region |
| 111 | ABC | America |
| 111 | ABC | London |
| 111 | ABC | Singapore |
| 222 | BCD | Dubai |
| 222 | BCD | Japan |
| 333 | CDE | Singapore |
now issue is like. for count have taken count(Distinct ID), but when we show in table name format name is getting repeated multiple times based on number of countries
Is there a way to show only unique names as well in table.
