Thank you for the response , but the issue is i need to display total at the end.
Below is how it should look line
Enrolled 1 2 3 Total
Count 0 8 8 17
Adoption 0% 50% 50% 100%
You example data makes absolutely no sense. 8+8=17? And 2 & 3 both equal 50% somehow. Give us some real data in an Excel spreadsheet, and you might be able to help.
Sorry the Total is 16.
My question is on how to have word "Total" in the Last column of the Row Enrolled
Thank you this solves my problem.
Appreciate your quick response