Hi Team,
I have set of data, which goes by name on month-on-month basis. The names have designation...
I want to see count of designation based on the set of name data...
A,B,C is master data. E,F is related designation. J,K,L,M is result table. Please help
I have set of data, which goes by name on month-on-month basis. The names have designation...
I want to see count of designation based on the set of name data...
A,B,C is master data. E,F is related designation. J,K,L,M is result table. Please help
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | JUL | AUG | SEP | Name | Role | JUL | AUG | SEP | |||||
2 | Amol | Amol | Amol | Amol | Sr.Manager | Sr.Manager | 1 | 1 | 1 | ||||
3 | Amit | Amit | Amit | Amit | Manager | Manager | 1 | 1 | 1 | ||||
4 | Akhil | Akhil | Akhil | Akhil | Developer | Tech Lead | 1 | 1 | 1 | ||||
5 | Navya | Navya | Navya | Navya | Developer | Developer | 4 | 4 | 4 | ||||
6 | Baishali | Baishali | Baishali | Baishali | Tech Lead | Sr.Developer | 1 | 1 | |||||
7 | Yogesh | Yogesh | Yogesh | Yogesh | Developer | Tester | 1 | ||||||
8 | Chetan | Chetan | Chetan | Chetan | Developer | Total | 9 | 8 | 7 | ||||
9 | Pavan | Pavan | Pavan | Sr.Developer | |||||||||
10 | Kanishtika | Kanishtika | Tester | ||||||||||