I have emp#, Hire_Date and Termination_date.
I want to count each employee every year starting from hire_date till his termination_date year comes.
If emp# 100 have hire_date 01/01/2013 and his termination_date is 31/12/2017. The this employee should be count =1 in year 2012,13,14,15,16,17.
And if any employee have hire_date and termination_date in same year then he should not be counted.
attach a packaged workbook to get a solution quickly
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...