• I like the empty Totals row option (hint hint)... see if you can figure that part out. You won't learn anything if you don't try things for yourself.

    BTW, it makes it much easier for people to help if they can recreate your situation or dataset... something like this:

    SELECT 'dfw' AS Location,123 AS CaseNumber,'2014-02-21 12:40:33.000' AS ComplaintDate UNION ALL

    SELECT 'dfw',452,'2014-03-17 10:29:26.000' UNION ALL

    SELECT 'dfd',478,'2013-02-21 12:40:33.000' UNION ALL

    SELECT 'dfd',789,'2012-02-21 12:40:33.000' UNION ALL

    SELECT 'dfs',125,'2013-02-21 12:40:33.000' UNION ALL

    SELECT 'dfs',145,'2015-02-21 12:40:33.000';