Get Total Based on Custom Field

Hi @TharidhiP  If I understood correctly that you wanted get sum value from detail lines (HSCode) and populate that in header field. 

If yes, then you need to create a variable in the header section and assign value expression as “Sum(DAC.FieldName)” and then assign this variable to the Header Field.

Here is sample example for your reference. I have customized Sales Order report that getting sum value of QTY at line level and assigning it to new Header field by using variable. Please find the screenshots for reference.

Hi @Naveen B, this solution takes into regard any QTY summation, but the requirement is to get the total if the line levels have the same HSCODE to cumulate their total, if not ignore.