summarize report with 2 tables , not working

[REEDZHOU]

Hi 

I create 2 tables, one covers operating info, the other with financial info, both are linking with order numbers, I tried to group them by gain or loss. the report is as below

GAIN/LOSS |  JOBS |  CW_KG | Profit

gain           100      500      500

loss            100      500      -350

total          100      500        -150

The reality is gain job 75, loss job 25, financial profit is correct. How can I fix this? thanks