Filtered/Grouped report from repeating tabled

[Jeremy]

I have this repeating table and need to total it like below.This is super
easy in SharePoint 2007 but I need to do it in Infopath 2007

Repeating Table:
Code# Reason Code Cost$ Notes:
00-001 CD $1000
00-002 DS $-1000
00-003 CD $5000
00-004 OR $1000
00-005 OR $1000
00-006 OR $-1000

Report: Group each Reason Code and total and count.
Reason Code Grouped | Total Cost$ by Code Count of Code:
CD $6000 2
DS $-1000 1
OR $1000 3