Good evening,
Hopefully I can explain this clearly. I've been banging my head against the wall all day.
I'm trying to create a clustered column chart with groups. When I try to show percentages it will break out the percentages across all of the groups, but I need it to do the percentage based upon each group. Enrolled, Attended, and NoSHOW are the columns that are grouped by CourseName. HOw can I get the column to break out the percentages based upon the total number of coursename? Basically the first group: enrolled / total of CourseName1, attended / total of CourseName1, noshow / total of CourseName1. And then for the second group enrolled / total of CourseName2, attended / total of CourseName2, noshow / total of CourseName2
Hopefully I made that somewhat clear.
| EMAIL | Enrolled | Attended | NOSHOW | CourseName |
| Email@somewhere.com1 | 1 | 1 | 0 | Azure101 |
| Email@somewhere.com2 | 1 | 1 | 0 | Azure101 |
| Email@somewhere.com3 | 1 | 1 | 0 | Azure101 |
| Email@somewhere.com4 | 1 | 1 | 0 | Azure101 |
| Email@somewhere.com5 | 1 | 1 | 0 | Azure101 |
| Email@somewhere.com6 | 1 | 0 | 1 | Azure101 |
| Email@somewhere.com7 | 1 | 0 | 1 | Azure900 |
| Email@somewhere.com8 | 1 | 0 | 1 | Azure900 |
| Email@somewhere.com9 | 0 | 0 | 0 | Azure900 |
| Email@somewhere.com10 | 0 | 0 | 0 | Azure900 |
| Email@somewhere.com11 | 1 | 1 | 0 | Azure900 |
| Email@somewhere.com12 | 1 | 0 | 1 | Azure900 |
| Email@somewhere.com13 | 1 | 1 | 0 | Azure900 |
