Regroup the xml data in RTF

Hi All,

Below you can see the sample XML data which i need to work in RTF Template. Here i need to group a data as follow.

First Group : PER_NUMBER

Second Group : CATEGORY_NAME

My expected result will be. i need to sum up the RUN value based on the category name and show the output for every employee.

OUTPUT format will be like

Person Number

Person Name

CATEGORY NAME

Total

Sample XML :

<GLB_PAY_ACTIVITY_REPORT> 

  <PA>

                <PA_INFO>

                    <EFF_DATE>2018-01-12</EFF_DATE>

                    <ACT_TYPE_NAME>Payroll calculation</ACT_TYPE_NAME>

                    <ACT_TYPE>R</ACT_TYPE>