Distinct values in the chart

[#1]

Hi,

If I load some data that might be duplicates, can I create a chart with DISTINCT dimension ? I don't want to count  them. I want to display in the chart only the distinct data.

How ?

Thanks in advance,

Claudiu

[sunny_talwar · Accepted solution]

List boxes and Table Boxes show distinct value from any dimension. or if you want to show it in a text box, you can do something like this:

=Concat(Distinct DimensionName, Chr(13))

HTH

Best,

Sunny

[#3]

Thank you very much for your answer!

[sunny_talwar]

No problem, I hope it worked the way you wanted it to work

[Anonymous]

Hi sunny,

Iam facing  same problem. But I want to display in the Straight table only the distinct data.

Please give me suggestion to my problem.

Thanks in advanced,

Suman