Calculate the percentage

[Sshasnk]

Hi Guys, I have a dataset where I have to calculate the percentage of occurance

Example: Input

Product Id	Apple	Mango	Banana
123	Yes
123	Yes	Yes
245		Yes
245		Yes	Yes
245		Yes	Yes
456
456	Yes	Yes
456	Yes

Rules: 

1. If the percentage is greater than 80% then put the column name should be in the comment and if it is lesser than 80% then put

two largest percentages example: 456 <- product id 

Example:

1. product id 123 for apple we have two yeses in the apple which is 100% because both the rows have yes and the rest does not so put a comment as an apple.

2. Product id 456 apple is 66.66% and mango is 33.33%. So both are less than 80% so put both of them in comment

Output: 

Product Id	Apple	Mango	Banana	Comment
123	100%	50%		Apple
245		100%	66.66%	Mango
456	66.66%	33.33%		Apple, Mango

[atcodedog05]

Hi @Sshasnk 

Here is my take on a dynamic solution.

Workflow:

Hope this helps : )