Forum Discussion
Excel pivot: Adding a summary percentage
I am working with categorical data - think of a survey with ratings from 1 to 5. In addition to the counts and grand total, I need to be able to add a percentage to summarize the top two categories. ...
With the AGGREGATE() or the LARGE() function you can display the two top values and sum them up. Then just divide by the sum and make it a percentage.
See also the enclosed document.
=SUM(AGGREGATE(14,6,B2:F2,{1,2}))/SUM(B2:F2)
It's not a pivot table. I hope you like it anyway.
The LAGRGE() function leads to the same result.
=SUM(LARGE(B2:F2,{1,2}))/SUM(B2:F2)