How to calculate percentage of a column by row / rows are different in all the column

[acaryasin01]

Hi Guys,

I have a data and I need to calculate row by row based on page no.

My daya is something like this;

Thanks in advance....

Company	Page no	Condition	Count	% of Count by Page no (DESIRED COLUMN)
XYZ CO.	2	Negative	2	11%
XYZ CO.	2	Neutral	15	83%
XYZ CO.	2	Positive	1	6%
XYZ CO.	3	Negative	1	7%
XYZ CO.	3	Neutral	13	87%
XYZ CO.	3	Positive	1	7%
XYZ CO.	4	Neutral	23	85%
XYZ CO.	4	Positive	4	15%
XYZ CO.	5	Neutral	5	71%
XYZ CO.	5	Positive	2	29%
XYZ CO.	6	Neutral	17	89%
XYZ CO.	6	Positive	2	11%
XYZ CO.	7	Neutral	8	89%
XYZ CO.	7	Positive	1	11%
XYZ CO.	8	Neutral	7	78%
XYZ CO.	8	Positive	2	22%
ABC CO.	3	Negative	1	7%
ABC CO.	3	Neutral	13	87%
ABC CO.	3	Positive	1	7%
ABC CO.	4	Neutral	23	85%
ABC CO.	4	Positive	4	15%
ABC CO.	5	Neutral	5	71%
ABC CO.	5	Positive	2	29%
ABC CO.	6	Neutral	17	89%
ABC CO.	6	Positive	2	11%
ABC CO.	7	Neutral	8	89%
ABC CO.	7	Positive	1	11%
ABC CO.	8	Neutral	7	78%
ABC CO.	8	Positive	2	22%

[Luke_C · Accepted solution]

Hi @acaryasin01 

Here's how you can do this:

• Summarize tool to get totals per page
• Join to get total back for each record
• Formula to compute % and format per your requirement

[KarolinaRoza]

hi @acaryasin01 

Attached is my way of solving this.

Karolina

[acaryasin01]

Cool👍👌

Thank you so much @Luke_C appriciated.

[acaryasin01]

Thank you @KarolinaRoza Your solution also worked same as above 👍