Unique Dimension Values in Chart/Table

[vardhancse]

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.

[Anil_Babu_Samineni]

Use Pivot Table

[mahaveerbiraj]

Hi Varda,

could you please attach  qvf file, So that i  can check.