I tried to build an example using your date, please look at the attached.
GroupItemLevel.qvw 156.2 K
Thansk for your reply as adviced you i writen the Expresion but the answer is coming with near to the required ans.
Files has been attached to understand my problem.
in attached file as per my expression the total is coming correct but in table item level its giving multiple rows. for exact error attached support error file (xlsx) with records Yellow background
pls provide a solution
Thanks & Regards