Hi Pls I have a sample data (Multiple rows) like this in a query in Cognos report studio:
Name City Amount Job
John Lyon 200 Teacher
Paul London 400 Sailor
Paulie Tokyo 700 Runner
John Lyon 200 Teacher
Paul London 400 Sailor
Paul London 400 Sailor
Paul London 200 Sailor
Paulie Tokyo 700 Runner
Paulie Tokyo 700 Runner
Paul London 400 Sailor
How can I get the following information (Distinct aggregation) (What code/Statement can I use)
Paulie Tokyo 700 Runner
Paul London 400 Sailor
John Lyon 200 Teacher
Change the value of the "Auto Group&Summarize" property to Yes.
autogroup and summarize didnt work
Can you reproduce the problem using one of the samples models and upload the report spec?
Quote from: a1003520 on 22 Nov 2016 01:50:25 PM
Hi Pls I have a sample data (Multiple rows) like this in a query in Cognos report studio:
Name City Amount Job
John Lyon 200 Teacher
Paul London 400 Sailor
Paulie Tokyo 700 Runner
John Lyon 200 Teacher
Paul London 400 Sailor
Paul London 400 Sailor
Paul London 200 Sailor
Paulie Tokyo 700 Runner
Paulie Tokyo 700 Runner
Paul London 400 Sailor
How can I get the following information (Distinct aggregation) (What code/Statement can I use)
Paulie Tokyo 700 Runner
Paul London 400 Sailor
John Lyon 200 Teacher
Can you tell us how this query is defined? You didn't manually code it as SQL, did you?
MF.