Rep Movement Calcualtion

[raiyanimv]

Hi All,

I have two challenges.

Challenge 1: to calculate the number of reps by their New/Old/Vacant status by month based on their call cycle

Challenge 2: to list the reps moving in, moving out and vacant by month based on their call cycle

I have attached the file with complete raw data as well calculation filed....

Thanks,
Mitul

 

[vletm]

@raiyanimv
Of course You would show some sample results too or how?
To make clear You used terms.
>> Would this be something suitable for Your challenge 1? <<

 

[raiyanimv]

thanks veltm,

You are right for challenge 1. here is the updated file with dummy results

Regards,
Mitul

 

[vletm]

@raiyanimv ... interesting ...
I tried to ask sample answers and You gave REAL DUMMY answers!
Do You want answers with same logic as You did or is there ANY clear logic?

I can make 'random' answers quickly!

 

[raiyanimv]

@vletm i don't have the formula set yet..... I am looking for results in the format same as dummy numbers in the updated version....

 

[vletm]

@raiyanimv
You can do those 'answers' as I did in that photosnap.
ex M4108 ... to which cell it adds value?
You just fill some nonsense dummy numbers.
... moving in, moving out ... what terms are those?
If You cannot do it even manually, then how to do it other way?

 

[raiyanimv]

@vletm

Thank you for your help.

Regards,
Mitul