Well, as your ProdAmount and Date are making it so you have 8 records, you remove those from the table.
This would result in 4 rows of data, based on the following dimensions: ID, RefID and the measure: Sum(SalAmount).
Though I don't know if this is the desired output.
Could you tell/show what 4 records your client wants to see exactly?
Would make it easier for us to find a solution that fits your needs.
In you're table you have two rows with RefID 101, one with ProdAmount 400 and one with 450. How would you choose which of those values to display in the ProdAmount column if you only want to show one line? Perhaps you want to replace the "ProdAmount" dimension with a measure? For instance "Max(ProdAmount)"? But in you're example you seem to select "Min" for RefId 101 and "Max" for 102, so you might be looking for something else.