Hi all,
I have a question on pivot tables, or if there are any other methods - please feel free to suggest.
I've attached my sheet on here, but essentially - I have a dataset that shows how much time a team will spend each month doing a task. The pivot table allows me to sum up the time per month by product - which gives an overview of how much time they'll need.
But I need to overlay this data by the maximum time that each team has. so for example, if team apple has maximum time of 10, and sum of tasks is 5, ideally I'd like to show 50%, and if it's 15, then 150%.
I tried playing around with "data bars" under conditional formatting, but this only shows a bar and doesn't provide a percentage. The goal is to show through sum of tasks if a team can do all of them, or they are over/under budgeted.
I can get the total expected time to be spent by each team, and I know what the max the team can spend, but I don't know how to bring those two datasets together so that we can show what percentage of time they have is booked, under booked, or over booked.
I know it's not the best explained post, so please let me know if you have any questions, and I will clarify. Thanks again for your help!
Bookmarks