AnsweredAssumed Answered

How can I filter and report this... ?

Question asked by m110270 on May 17, 2014
Latest reply on May 18, 2014 by philmodjunk

Title

How can I filter and report this... ?

Post

     Hello

     I'm pretty new to FM but have been successful with some basic DB already. 

     Now - I really struggle to find out how... 

      

GOAL: 

         
  •           For our company I would like to see a reporting that allows me to filter / report the following: 
  •      
  •           For about 100 employees: 
  •      
  •           Total contracted hours / week:  per DEPARTMENT (Main category) but also for the sub-category of ROLE within a department.  
  •      
  •           Every dep. has various ROLES (Rolle in my screenshot). 

      

BACKGROUND: 

         
  •           We do see employees moving from one department to the other quite often. With that they do change their current role and also weekly contracted hours.  This is due to promotions, seasonality, exit and new starters.  
  •      
  •           We have to follow strict quarterly budgets per department (we can joggle a bit with how we spend these hours to the roles within the department)
  •      
  •           e.g:  An employee could work as a Associate (Verkäufer) in January on a 16hrs contract but could then move to the LOGISTICS department next month to a new role and even with a new contracted hours. 

      

MY TABLE SO FAR: 

         
  •           1 FIELD for employee name
  •      
  •           1 filed per month per  employee ROLE (role_Jan.... role_Feb... )
  •      
  •           1 field per month per employee DEPARTMENT (dep_Jan... del_Feb...)
  •      
  •           1 field per month per employee HOURS (hour_jan... hour_feb...)
  •      
  •           SEE SCREENSHOT
  •      
  •           Text fields for ROLE and DEPARTEMENT are being filled over a drop-down-list
  •      
  •           in one dataset I input data for all year per employee.  This is giving us a good overview if we search for the employee. 

      

      

      

STRUGGLE WITH REPORTING THE FIELDS

         
  •           I can't figure out what and how I can report the totals per month for: 
  •      
  •           TOTAL HOURS per Department / month
  •      
  •           TOTAL HOURS per Role / month
  •      
  •           Ideally I would also get a Headcount
  •      
  •           and ideally I could filter select which department and which month I want to see or report. 

      

     Any tip is very much appreciated - thanks a lot

     best regards from Switzerland / Europe

     Marc

DB_Screenshot.png

Outcomes