Forum Discussion

Sisi's avatar
Sisi
Regular Visitor
4 years ago

Staffing plan - Weekly

Hi,   We have a forcast staffing plan for each project. and it is weekly basis for 2 years.    1-The column header should be Week ending date. I already have a Date table in quary, but I couldn't...
Need Help
Sisi's avatar
Sisi
Regular Visitor
4 years ago

I guess I should create a second table for FTE in excel.

Btw dates still not working. If I change rows and columns, then I need to add names manually.

I have more than 100 weeks and 300 employees. Are there any ways that I can group headers in the Fields?

 

 

 

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Sisi 

 

Yes you would want the dates to be in a date column and all the employee numbers to be in another column?

  • Sisi's avatar
    Sisi
    Regular Visitor
    4 years ago

    Hi,

     

    I want to have a table the same as my excel file, so dates should go to the values, and employees and project number needs to go to rows.