[#10991] - 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.