Hi All
In one of the requirement I have to show opening and closing emp headcount on month on month basis in my dashboard . also I have to develop the water fall chart to show the current Month and current year opening and closing Emp headcount with hiring and leaving of that month . am using master calendar and on selection of that the chart will filter out accordingly . formula to calculate the opening and closing are given below
Opening balance = closing of the last month
Hiring = Current month joining
Leaving = Current month Leaving
Closing - Opening + Joining -leaving
can someone help me to achieve this requirement
| Month | Opening Balance | Hiring | Leaving | Closing |
| Apr-17 | 1234 | 10 | 5 | 1239 |
| May-17 | 1239 | 5 | 4 | 1240 |
| Jun-17 | 1240 | 20 | 10 | 1250 |
| Jul-17 | 1250 | 25 | 4 | 1271 |
| Aug-17 | 1271 | 20 | 10 | 1281 |
| Sep-17 | 1281 | 10 | 10 | 1281 |
| Oct-17 | 1281 | 40 | 20 | 1301 |
| Nov-17 | 1301 | 10 | 5 | 1306 |
| Dec-17 | 1306 | 25 | 8 | 1323 |
| Jan-18 | 1323 | 32 | 12 | 1343 |
| Feb-18 | 1343 | 12 | 6 | 1349 |
| Mar-18 | 1349 | 28 | 20 | 1357 |
| Apr-18 | 1357 | 5 | 20 | 1342 |
| May-18 | 1342 | 9 | 5 | 1346 |
| Jun-18 | 1346 | 0 | 0 | 1346 |
