I have a field looks like this:
BCCH, ROOM#1
BCCH, ROOM#123
BCCH, ROOM#523
OHHCO, APT#6
MAWESTTOWN, FLOOR3, ROOM 302
MAWESTTOWN, FLOOR7, ROOM 732
What I need is to show 1st part of the filed to the report. Then sub-count and Total-count the 1st part. In another words, the report would be...