Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In this example, first bar shows the total headcount and rest of them are like leavers, late entry, others, transfer out which I would like to show the bar's reducing as employee count reduces from previous month (refer first bar). However, when it comes to Joiners the bar should move up and after the other addition or subtraction (eg. Joiners, Leavers, conversion etc) it should be in the level of Actual headcount.
I used simple expression in Bar Offset as Sum([HC Previous Month])-Sum([Leavers])-Sum([Late Entry OUT]) and so on. Also for joiners I tried adding/subtracting them but still don't get the accurate chart.
Thanks a lot for your help...