Displaying only unique records in a Table Object

[#1]

Hi,

Is there any syntax which only displays unique records based on a particular column?  For example, I have ID numbers appearing in one of the column and I only want the unique IDs to appear in the table (i.e. no duplicates).  Is there any way of doing this? 

Any help would be greatly appreciated.

Thanks.

Rajiv.

[rajni_batra]

use distinct() function.

hope it help!!!!!

[#3]

Thanks Rajni for getting back to me.

How do I go about implementing that in a Table Box?

My column name is Sales_ID

Thanks.

[swuehl]

If I understood your request correctly, you can use a calculated dimension to filter your ID field, try something like

=aggr(if(count(ID)=1,ID),ID)

You can use this as field expression in a list box or calculated dimension in a (straight or pivot) table chart.

This might be not very performant on large data, so you could also use something similar in the script, creating a new field flagging the unique ID values.

Hope this helps,

Stefan