Forum Discussion
Staffing plan - Weekly
Hi Sisi
You would still connect your data table to the date table on the date, even if your date is only for the end of each week.
If you bring the data table into your model you should flatten the data, meaning instead of having it run across in columns, you want it to run down in rows. You could then filter it to find where the hours = 2
Thank you, but I am not looking for hours=2. Sorry I should have explained more about my second question.
I want to have a FTE ( Full Time Equivalent ) chart. Some employees should work 40 hours a week and some 50. I need to add a condition column to my data table, so then it divids hours for each employee by 40 or 50 based on my condition. The same chart but just all the hours divided by 40 or 50.
Hi Sisi
If you can identify the FTE in your data, you could then apply the dividing by 40 hours for them?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?