Identical Lines in report not automatically totaling

[keating101]

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

[blom0344]

Did you set the aggregate of the amount measure to 'total'?

[keating101]

that did the trick - many thanks.
Shaun