Displaying Unique Data in a Column and Adding Filters to a Table

[#1]

Hi,

Is it possible within a Table Box Object to only display unique records based on column?

For example, I have a Sales ID column and there are duplicate Sales ID's in this column when I add in another columns.  Is there a way I can show the unique Sales ID with the other columns in a table box?

Also, is it also possible to add a filter to a table box?  I have a category column and I only want to want to show the dataset for a subset of categories.

Any help would be greatly appreciated.

Thanks.

Rajiv.