Hello!
We have a table in which we enter the planned time we will spend on each project.
We would like to have a pivot table showing for each coworker how much time in percent of their working time is planned in advance.
for example I personnally work 153 hours a month. I would like to see what percentage of my 153 hours is dedicated to my different projects (which works in the example) - but also to see at what percentage I work (which would be the sum of October % but excluding the 153 hours of "temps de travail").
I have unfortunately failed at that point...
Thank you in advance for your help,
Geneviève
Hi Geneviève,
The image didn't upload correctly. Please upload a sample Excel file rather than an image.
Mynda
there
Hi Genevieve,
Your data isn't in a suitable format for a PivotTable. You should not have a separate column for each date. You should have one column for the date information and one column for the value (hours). This is why you can't create the calculations.
You can use Power Query to unpivot the data into a tabular format which is required for PivotTables.
I also removed the last row in the table containing the hours goal as this is the wrong place for it and you already have it correctly recorded in a separate column.
You can then use a calculated field for the percentage calculation you want. See file attached.
Mynda
Great!
Seems like I am not there yet - this is my next chapter.
Looking forward to being more fluent with this!
GG
