Grouping and sum the RUN values of balances using XSLT

Hi Folks,

I have a below requirement to group by and sum the RUN values for each balance under Canada tax balances using the XSLT template with input as XML. Please let me know any pointers/leads on how to develop this using the XSLT template.

And also, how to assign a dynamic value to a variable in the XSLT template? for ex.

<amount balance_name="@REPORTING_NAME">

</amount>

Here REPORTING_NAME should display for each balance name from the XML file

Thanks,

Deekshith.