SSRS Row Grouping help needed please

Question

I'm guessing this is very simple but I am missing something and need help please.

My dataset looks like:

 CITY         STREET      HOUSES
 Norton       Main St     10
 Newton       Main St     30
 Providence   Angel St    15
 Boston       State St    50

I created a row group which groups by Street, but I am still getting 2 rows broken down by HOUSE numbers. Like this

 STREET        HOUSES
 Main St       10
               30
 Angel St      15
 State St      50

How do I SUM(HOUSES) based on the STREET column? I want my output to look like this (using SSRS grouping not SQL)

 STREET        HOUSES
 Main St       40
 Angel St      15
 State St      50

Thanks in advance!

Answer 1

remove the details group and enter your aggregate expression Sum(Houses) into the cell. this will then group on street as you are expecting and not return each row from the dataset.

its not completely unlike this question, but this one also had column groups.