Forum Discussion
Solved
New Joiners Count
Dear Experts, Need to calculate how many employees joined each month but the trick is in the following table example: (Remarks column is given for help) S.No Payroll Month Code Name CNI...
Dear Rupak_bi,
I wanted the result same as in the following table visual:
Note: Have the silcer of calendar[month], calender[year] and department [name] on the canvasMonth Name Hire Jan Imtiaz 1 Jan Hussain 1 Feb Waseem 1 Feb Khurram 1 Feb Arbaas 1 Mar Maheen 1 Mar Idress 1 Regards,
Saad Hanif
Hi I think below will be your expected out based on data. Feb count will be 3 , Khurram, Arbaas, Waseem
Dear Rupak_bi,
I wanted the result same as in the following table visual:
Note: Have the silcer of calendar[month], calender[year] and department [name] on the canvas
| Month | Name | Hire |
| Jan | Imtiaz | 1 |
| Jan | Hussain | 1 |
| Feb | Waseem | 1 |
| Feb | Khurram | 1 |
| Feb | Arbaas | 1 |
| Mar | Maheen | 1 |
| Mar | Idress | 1 |
Regards,
Saad Hanif
just update the table relationship to "firsthiredate"
If this solves your problem, Plz accept it as solution.
- Hi , Thanks for your reply. Please accept my last reply as solution so that other fellow can refer.