samilam
Technical User
- Jul 9, 2003
- 17
I have created a field from two others, {name}&{location}. I want to get a summary on a seperate field in the same table, but a distinct sum based on the new field, {name}&{location}. I created a group based on my {name}&{location} field, and moved my {amount} field into the group header, but when I insert a summary, I get a total based on each record, not the distinct sum I am looking for. Any ideas how I can do this?
I am on CRXi R2, on a SQL db on an ODBC connection.
Any help would be great!
Sam
I am on CRXi R2, on a SQL db on an ODBC connection.
Any help would be great!
Sam