I am looking to create a report of the FTE data. I have start and end dates for different departments and projects. I am looking to have the FTE data to be displayed between all the start and end dates for each department. I created a gantt view to show the data from start to finish date for each individual project - but when I try to roll it up to the Department level the data gets messy.
I think you need to re-shape the data with pivoting.
Your data seems complicated and I am hesitating to re-build everything, but here is a direction.