Hello Friends,
I want to show the cumulative sum of headcount(YTD Headacount) month on month increase and decrease in the headcount .
Attached is the sample qvw application for the same.
Scenario:
If i select year as 2014 then in the Chart Absolute Headcount for the month of Nov and Dec values should be reflected as 14 instead of 5 because there is no hire and termination in the month of Nov and Dec and in the Month of Oct the headcount was 13 so it should be reflected as YTD headcount.
Please suggest how to get the above output.