Can any one please help me on below requirement. I have a Table like below
From the above table need to show top Employee Names by Department and Top Employee count by Department like below table
I have tried below expressions the First expression for Employee is working fine when there is only one top employee but in Electronics Department there is Two Top Employees Named Raj and Suraj there getting null instead of there names, in Groceries its working fine.
Please help me to modify the below Employee Expression for showing all Top Employees like above 2nd table.