crystal report - Subtract result for each item

Question

On Crystal Report, I want to show My_Qty, which is {Table.1st_Qty}-{Table.2nd_qty}, for each item.

My desired outcome is

Item 1   5  0  5(My_Qty_1)
Item 2   6  0  6(My_Qty_2)

But my current CR shows

Item 1   5  0  11
Item 2   6  0  11

Is there anyway that I can adjust {Table.1st_Qty}-{Table.2nd_qty} to print out what I want?

I have tried 'Running Total Fields' but no luck. I've been googling around but can't find an answer for my case. Thank you so much in advance!

Answer 1

use whileprintingrecords:

It will do sum while reading data from start to end.