Group By Percentages in Power Query

Hi,

Is this what you are looking for?

1. Loaded your table as a source in the power query.
2. Reordered columns according to your request.
3. 1st grouping stage is to group by Employee and sum all values.
4. 2nd stage, is to add the sum of Total For Employee.
5. 3rd stage, is to collect all rows, Sum By Employee By Dept.
6. Expand Sum By Employee By Dept column (Dept., and Value).
7. Reorder and rename columns.
8. Add a new column to do the divide.
9. Finally load the result to the Excel table, and adjust the cell format to %