I have fact table which has measures employees present and employees absent and other keys etc date dimension ,There is also another table name employee which has all employees detail name,employee id etc .What I need to get is daily employees turned up for work each dept wise,along following lines:
one day information
Organization total emp working cnt
IT 3000 2148
Branch 2000 1567
Our Requirement is we need Total employee count by Organization and count of employees who came to office daily.Any help will be appreciated.
Thanks,It is solved.Took two data items one for employees present and employee absent and wrote a case statement by flagging the present and absent employees.