Hi all, I'm very new to using Power Pivot, so there's probably an easy solution to this, but for the life of me, I can't figure it out...
My source data contains a list of employee IDs with the number of hours charged on various transaction dates.
I have added a column to my source data that assigns a category to each row, depending on the transaction date. For example, if the transaction date falls between 8/1/2017 and 7/31/2018, the category would be "Year 1"; if the transaction date falls between 8/1/2018 and 7/31/2019, the category would be "Year 2" and so on.
A second table contains a column of all the categories and the total number of working hours in each category.
I've loaded both tables into a Data Model and created a relationship between the category columns.
I've created a Pivot that shows Employee Names and the sum of hours charged by category. But I also want to show the sum of hours by percentage of the total number of working hours in that specific category. How do I do this???
My source data contains a list of employee IDs with the number of hours charged on various transaction dates.
I have added a column to my source data that assigns a category to each row, depending on the transaction date. For example, if the transaction date falls between 8/1/2017 and 7/31/2018, the category would be "Year 1"; if the transaction date falls between 8/1/2018 and 7/31/2019, the category would be "Year 2" and so on.
A second table contains a column of all the categories and the total number of working hours in each category.
I've loaded both tables into a Data Model and created a relationship between the category columns.
I've created a Pivot that shows Employee Names and the sum of hours charged by category. But I also want to show the sum of hours by percentage of the total number of working hours in that specific category. How do I do this???
