Percentage of Rows

[mehmetalikarabulut]

Suppose you have a column what about sales amounts. How can I get the sum of all lines for this column and print next to each line? I want to print the percentage amount next to each row according to the total quantity. For example:

[AngelosPachis · Accepted solution]

Hi @mehmetalikarabulut ,

To get the total amount of all sales you have to use a summarize tool to aggregate them all up, and then with an append fields tool you can place that value right next to each record.

Finally, with a formula tool you can get the percentage of total for each record

Note that in your formula, to add the % suffix you have to convert the numeric value into a string and round it to no decimals.

Hope that helps, let me know if that worked for you

Cheers,

Angelos

[mot]

You can use summarize tool to get the total of the sale amounts and then use append tool to add it to each row. After that, you can use the formula tool to get the percentages. I hope this helps.

[mehmetalikarabulut]

Thanks a lot. Its work.

[Qiu]

@mehmetalikarabulut 

As a convention, you should mark the solution as accepted. 😁

It is an encourage to the author, also others can refer the solution.