Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: keating101 on 27 May 2013 10:01:59 PM

Title: Identical Lines in report not automatically totaling
Post by: keating101 on 27 May 2013 10:01:59 PM
Hello,

I have attached a screen shot to visualise my dilemma.

Through an SQL query, i have brought together an account number field, and the amount. Running in the background is a period/year prompt.
The problem i have is that the final report is not grouping identical account codes into one line, which i need it to.

Any solutions?

Thanks,
Shaun
Title: Re: Identical Lines in report not automatically totaling
Post by: blom0344 on 28 May 2013 05:43:22 AM
Did you set the aggregate of the amount measure to 'total'?
Title: Re: Identical Lines in report not automatically totaling
Post by: keating101 on 28 May 2013 05:44:51 PM
that did the trick - many thanks.
Shaun
Text only | Text with Images