Distinct values in table box

[#1]

My issue is i need to show only distinct scar numbers only.

Please find the screen shot.

[Gysbert_Wassenaar]

Then you need to remove any column from the table box that contains unique values per scar number, i.e. Part Number and Part Description

[#3]

As per requirment i need to have those feilds.

[rbecher]

Then it's maybe better to use a straight table (chart) with Dimension SCAR Number and aggregate all non distinct text fields by Concat(), all measures with sum/min/max etc..

- Ralf