I need some help building a pivot table. I have some employee data, with person id(means employee id), Name(means employee name), Country(this is the country where employee works from), supv person id(employees supervisor id) etc. Since one supervisor may have many employees reporting to them, 'supv person id' may be same for different employees.I need to build a table which says how many supervisors have 1 employee reporting to them(also said as direct reports), how many supervisors have two direct reports, how many have three and so on. And this should also work with Country that we select. Please find an example below for how this should work. This is very urgent request. Any help would be greatly appreciated.
Please let me know in case anything is not clear in my example. Thanks!