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 %

Administrative Note:

Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as approriate) in the post in question (for the benefit of members unable to download attachments).

This is about making your assistance accessible to all.

Thanks.

Originally Posted by AliGW

Administrative Note:

Where you have provided a workbook solution, please also include a clear explanation of what you've done and how (including formulae/code as appropriate) in the post in question (for the benefit of members unable to download attachments).

This is about making your assistance accessible to all.

Thanks.

Thanks for the advice, I will always do that from now on.

Did I did it the right way?