Duplicates are not summing in crosstab in ireport desighner

class_sec religion total_fee

1 hindu 100

2 muslim 300

3 jyana 400

3 jyna 200

this is my input

I have done group by in mysql on class_sec,religion in mysql

class_sec religion totalfee

1 hindu 100

2 muslim 300

3 jyana 600

when I cross tab in jaspersoft i reports it's displaying like as below

hindu muslim jyana totalfee

class_sec 1 100 0 100

2 0 300 0 300

3 0 0 400 400

3 0 0 200 200

but I want it as followed

hindu muslim jyana totalfee

class_sec 1 100 0 100

2 0 300 0 300

3 0 0 600 600

Could you please look into this issue and let me know any feature is available in i- reports?

For clear view please find attachment.