Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I Created 3 measures. I need to implement Water fall chart.
previous month Head count=Count({<CDate = {'05/01/2016'}>}DISTINCT([Head_Count.Emp. Id]))
Current Month New hires count=count({<Newhires.CDate_NH={'>=06/01/2016'}>}[Newhires.Emp. Id])
Current month Exit count=Count({<CDate = {'06/01/2016'}>}DISTINCT([Head_Count.Emp. Id]))
Current month Head count=
(previous month Head count+Current Month New hires count-Current month Exit count)
1st Bar : previous month Head count
2nd Bar : Current Month New hires count
3rd Bar : Current month Exit count
4th Bar : Current month Head count
Please help me.
Thanks,
Kalyan Krishna
You want something like this Kalyan?
You want something like this Kalyan?
Something like this?
Thanks Sunny
Thanks Clever Anjos
No problem at all