Forum Discussion
% per group
I have Agents that belongs to a group, like the sample data below, what I like to do is the % not being of every agent of every group but be % relative to its group.
Agent Group Tickets closed %
| Analista | Grupo | Tickets Fechados | %GT Tickets Fechados |
| Jessica Brito | 02 - Vendas | 26 | 5.94% |
| Jonatas Cruz | 02 - Vendas | 35 | 7.99% |
| Rafael Ferreira | 02 - Vendas | 21 | 4.79% |
| Vanderlei Gabriel de Souza | 02 - Vendas | 25 | 5.71% |
| Heliberta Siqueira | 03 - Store Manager | 17 | 3.88% |
| Luciano Pereira | 03 - Store Manager | 1 | 0.23% |
| Stephany Marques | 03 - Store Manager | 33 | 7.53% |
| Caio Augusto Silva Santos | 04 - E-commerce | 14 | 3.20% |
| Rafael Cavalcante | 04 - E-commerce | 3 | 0.68% |
| Rafael Garcia | 04 - E-commerce | 8 | 1.83% |
Hi Varela，
How do you get the sample % data, based on your description, the percentage of Jessica Brito should be 35/(26+35+21+25)=32% rather than 7.99% given. Or you post part of your data?
First, please create a measure to calculate the total sum of each group. Then create a calculate column to get what you want.
Total group = CALCULATE(SUM(Table15[Tickets closed]),ALLEXCEPT(Table15,Table15[Group]))
Percentage = Table15[Tickets closed]/Table15[Total group]
If you have any question, please feel free to ask.
Best Regards,
Angelia
6 Replies
I dont understand ur question.
You want the % to displayed for every agent out of his/her group.
Eg . Jessica Brito belong to group 2
Formula = Tickets closed by Jessica / Total Tickets closed in Group 2
yes, thats what I want, don't really know how to do this though
Hi Varela，
How do you get the sample % data, based on your description, the percentage of Jessica Brito should be 35/(26+35+21+25)=32% rather than 7.99% given. Or you post part of your data?
First, please create a measure to calculate the total sum of each group. Then create a calculate column to get what you want.
Total group = CALCULATE(SUM(Table15[Tickets closed]),ALLEXCEPT(Table15,Table15[Group]))
Percentage = Table15[Tickets closed]/Table15[Total group]
If you have any question, please feel free to ask.
Best Regards,
Angelia
