Listing portals and Real Records

[Lawlerdev]

I have a list of bank transactions Payments and receipts. When I go to the Bank I group the list of receipts together under one Lodgement date and code.

What I want to do is get a list similar to my bank statement which shows each payment but instead of showing each receipt it just shows the total lodgement. I can do this in a summary report but I need to do this in normal browse mode.

I have setup a self join relationship based on lodgement date and put the totals from the portal on the layout but I can't seem to stop all the other lodgement transactions from appearing.

I enclose a rough if my layout and as you can see the first 4 records are copies of each other which I don't want displayed.

Any help greatly appreciated as always.