For some reason my users want this:

line 1 product A 10
line 2 product A 5
line 3 product A 50 65

Where the 65 is the total for the product A group.

So because they want it on the same line at the bottom of the group i guess i have to include it in the item band, so how do i know it's the last row in the group and hide/show accordingly?


(Platform 1.7, reporting