What Function need to use to eliminate duplicate values in Report Studio

[cognoshelp@ymail.com]

Hello All Garus,

I need function in report studio which eliminates duplicate values in report studio.

eg: I have a column

COLUMN XYZ
Values of this column are:
ABC
CDE
CDE
FGH
FGH
FGH
IJK
IJK

What I want is like
ABC
CDE
FGH
IJK

I hope it is clear if not please let me know

I need function which I can use to filter this duplicate values just like oracle function like "DISTINCT"               

[JGirl]

you could group them?

[vivek.bevan]

You can use distinct function to show the column.

~Vivek

[blom0344]

If you fetch no facts from the database and your XYZ column is assigned as an attribute, then Cognos will automatically add a distinct clause to the SQL generated..

[cognoshelp@ymail.com]

Thanks for your response

But its already grouped and distinct function is not work in this case.
I have outjoin to it in FM.

If you fetch no facts from the database and your XYZ column is assigned as an attribute, then Cognos will automatically add a distinct clause to the SQL generated..

[the_xxx]

trim the data item and then do distinct....give a shot!