Movement of Employees across Departments

[Anonymous]

Hi Everybody,

I have a scenario where requirement is to show the YoY (Year over Year) movement of Employees across Departments.

Some scenarios: Consider we are doing 2013 vs 2014 comparison

* An Employee was at Dept level D1 in 2013. In 2014, he/ she moved to D2

* An Employee was at same Dept level in both 2013 to 2014

This has to be depicted in the below format.

Dept (2013 / 2014)	D1	D2	D3	D4
D1	<count of Emp who stayed in D1>	<count of Emp who moved from D1 to D2>
D2
D3
D4

Request your inputs in solving this.

Thanks,

Vijit

[Anonymous]

Hi Jatin,

Thanks for the response. Let me go through the solution you've come up with and try implementing here with the actual data. Will let you know abou the status once I am done.

Thanks,
Vijit

[Anonymous]

Thanks Kush,

I am going to implement the solutions shared by you and Jatin and see if they solve my problem here.

Regards,

Vijit

[vardhancse]

Its a kind of Slowly Changing Dimension, we can achieve this by creating link tables using the resident tables.

[Anonymous]

Kush141087‌  JATINKOLHE

Hi Guys,

Thanks for the effort you've put in. I did went through the scenarios and they are perfect for Current vs Prior Year. Even I went along with a similar solution at my end earlier.

However, there might be another scenario where user wants to analyse 2104 vs 2014 (i.e. movements within the same year) and 2013 vs 2015 (i.e. when the difference is more than a year). Sorry to bring this at this point of time.

Do you think this would be feasible?

Regards,

Vijit