How to group dynamic row table by column and calculate subtotal for each group in Adobe InDesigner?

[#1]

Hi All

How to group dynamic row table by column and calculate subtotal for each group in Adobe InDesigner?

For sample data if i require to group by WHT Code and sum BaseAmount,WHTAmount

[#2]

I understand what your trying to archieve. But as long I don't know the stucture of you PDF form, I can't help.

[#3]

Hi

Do you have suggestion?

[#4]

it look like below grouping by WHTCode

Thank you

[#5]

What does the forms hierarchy look like?