Forum Discussion
Matrix to Manage Human Resources between Projects
Hi experts, I have to create a matrix reporting how many people in a project and how many projects a person is currently involving in. Ideally, I expect to have a table as below: Pr...
v-yalanwu-msft
Community Support
Community SupportHi admbinp ,
As @HarishKM said，you can try to use countx function.
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem.
Best Regards,
Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.