I have a fact table called "factCensus" in which I maintain one record for
each day an employee is "active" in the company (e.g. if an employee is
active for March & April then there will be 61 records). In this fashion all
employees of various branches have their records populated in the
"FactCensus".

To get a count of all "active" employees I would COUNT the records with the
Max(Calendar date) for each employee.

How do I dynamically calculate the opening headcount balance given that an
end user could be asking for any date range.

Any Help is greatly appreciated.


--
Thank you,
Ashok G