Hi,
I have below set of data with "n" number of fields
| DEPT_ID | Name |
| HR | ABC |
| HR | XYZ |
| HR | PQR |
| IT | IT1 |
| IT | IT2 |
| ADMIN | Admin1 |
| ADMIN | Admin2 |
| ADMIN | Admin3 |
| ADMIN | Admin4 |
My expected output should be, i want count of entries based on group level of DEPT_ID column
Expected output :-
| ID | Name | Count |
| HR | ABC | 3 |
| HR | XYZ | 3 |
| HR | PQR | 3 |
| IT | IT1 | 2 |
| IT | IT2 | 2 |
| ADMIN | Admin1 | 4 |
| ADMIN | Admin2 | 4 |
| ADMIN | Admin3 | 4 |
| ADMIN | Admin4 | 4 |
Appreciate your help :)
Thank you
