Distinct column by account Help

[cbyrne123]

Hello, not sure if this can be done but i have created a list view report column1 = Account, column 2 = account name, column 3 has a sales total, however on several accounts i.e. 10180 has two sub contracts fro the same account with slightly different account names, each of these has a total but i need to get these just to show the account as one with one total if this makes sense.

I have tried using distinct in the properties and then group but nothing see to work.





Many Thanks

Chris

[Lynn]

You could try to set an aggregate function on the account name such as maximum or minimum. You are having a problem because I suspect the generated SQL is doing a sum on the sales amount with group by on both account and account name. Since the account name varies you need to figure out how to display only one name per account number.