SQL Reporting Services Expression, how to SUM

I have a Data Set in SQL Reporting Server. I attached the code below. Data produces following results:

DisplayName, FirmName, Address, City, State, PostCode, ***(BUID)***, ***(Count J.JobNo)***
BUID stands for "BusinessUnit ID" (ex. Los Angeles, San Francisco, New York)

In Report Designer, I grouped by BUID. So it categorizes all results by BUID (location).
I need the "Expression" to Give me the total of the "Count" for each BUID.

Desired Results: --Need Total for each buid...already have everything besides the total for each BUID
*Los Angeles
DisplayName, FirmName, Address, City, StateName, PostCode, 5
DisplayName, FirmName, Address, City, StateName, PostCode, 2
DisplayName, FirmName, Address, City, StateName, PostCode, 3
                                                                                                    10
*San Francisco
DisplayName, FirmName, Address, City, StateName, PostCode, 7
DisplayName, FirmName, Address, City, StateName, PostCode, 2
DisplayName, FirmName, Address, City, StateName, PostCode, 3
                                                                                                     12
So I already have everything besides those totals in the footer of the "Group".
I tried =SUM(FieldName, Dataset), but that only gives me the entire total, I simply need each Group's total, how do I alter that expression?

Thank you in advance, I appreciate your time.

Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:

SELECT C.DisplayName AS 'Contact', F.FirmName, F.Address, F.City,
S.StateName, F.PostCode,  (SELECT @JobDateFrom + ' ~ ' + @JobDateTo) AS JobDates, B.BUID,
COUNT(DISTINCT J.JobNo) AS 'Jobs'
FROM Jobs J JOIN JobsParties JP ON J.JobNo = JP.JobNo
            LEFT OUTER JOIN JobsPartiesSvc JPS ON JP.JobPartyNo = JPS.JobPartyNo
            LEFT OUTER JOIN Contacts C ON J.OrdContactNo = C.ContactNo
            LEFT OUTER JOIN Firms F ON C.FirmNo = F.FirmNo
            LEFT OUTER JOIN State S ON F.StateNo = S.StateNo
            LEFT OUTER JOIN Invoices I ON J.JobNo = I.JobNo
            LEFT OUTER JOIN BU B ON B.BUNo = J.BUNo
WHERE J.Status NOT IN (712,812,811)
AND J.JobDate BETWEEN @JobDateFrom and @JobDateTo
GROUP BY C.DisplayName, F.FirmName, F.Address, F.City, F.PostCode, S.StateName, B.BUID