Replace the amount with the precentage.

[phoebe_90]

step1

Figure out the percentage of the Amount in local currency in each row to the amount with the same Document Number and tax code as this row.

step2

Replace the value of Amount in local currency with the percentage.

For example

Transfer sheet1 to sheet2

sheet1

Document Number	Account	Amount in local currency	Tax Code
19000498	66020000	823.88	J1
19000498	66020000	7.55	J2
19000471	66020000	141.51	J2
19000471	66020000	1472.56	J1
19000477	65010000	5856.6	J2
19000477	65010000	5856.6	J2
19000477	65010000	5977.36	J2
19000477	65040000	2895.53	J1

sheet2

Document Number	Account	Amount in local currency	Tax Code
19000498	66020000	99%	J1
19000498	66020000	1%	J2
19000471	66020000	9%	J2
19000471	66020000	91%	J1
19000477	65010000	28%	J2
19000477	65010000	28%	J2
19000477	65010000	29%	J2
19000477	65040000	14%	J1

[martinding]

Hi @phoebe_90 ,

1. You can use the Summarize Tool to group by on [Document Number], and Sum up the [Amount in local currency]
2. Then use the Join Tool to join the Summarized part with the original data, join on Document Number, keep only the Summed value.
3. Use the Formula Tool, and divide the original [Amount in local currency] by Summed value * 100. You can use ToString([Amount in local currency]/[Sum_Amount in local currency]) * 100) +"%" to get your desired format.

[Yoshiro_Fujimori · Accepted solution]

@phoebe_90 ,

At step 3 of @martinding , you may need to change the data type to string, to add "%" to the number.