distinct option on groups [message #88648] |
Fri, 03 January 2003 11:35 |
myles
Messages: 4 Registered: June 2001
|
Junior Member |
|
|
I am looking for a feature that will allow me to count distinct records for a group on my reports. I am using reports 6 and only have the option to count the records but duplicates are included in the total where I am only interested in distinct records. Is there any way to sum only distinct records at the group level?
|
|
|
Re: distinct option on groups [message #88657 is a reply to message #88648] |
Wed, 08 January 2003 07:46 |
Venky
Messages: 52 Registered: October 2001
|
Member |
|
|
In the query, select distinct values. Put a summary column with count in the respective group. It can be in any level like group or outside the group also. You may display the selected distinct value or you need not display the values. You add a field in the layout and map the source as the summary column.
|
|
|