Greetings, I have a list of names with that were all polled on 4 specific dates (there will be more, but 4 for now) I would like to get a listing of percentage of each type of response over the 4 dates. I'm easily able to see this using a pie chart (each count is shown as a numeric count, and as a percentage of the total count). I'm trying to find a way to show percentage of each response type to total responses in a matrix. The rows are the names in the group, and the columns are the different responses. I'd like for the matrix to show percentage of the subtotal for each response in the column. I'm sure that there's a way, but I'm having a hard time finding it.
Solved! Go to Solution.
@CBloome77 , You can use percent of total or percent of subtotal
Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37
Thanks Amit! That's exactly the solution I was looking for!
@CBloome77 , You can use percent of total or percent of subtotal
Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
106 | |
80 | |
72 | |
48 | |
47 |
User | Count |
---|---|
157 | |
89 | |
81 | |
69 | |
67 |