I show detail lines similar to that shown below:
Cost Value
123 40.00 11,600
333 35.00 5,500
123 40.00 11,600
I show the total of the three entries for cost (40 + 35 + 40) but for the value column I only want to total (11,600 and 5500). I want to exclude 11,600 for the second record that has the same # as prior records (in this case 123). How would I be able to accomplish this? Thanks in advance