Forum Discussion
Anonymous
7 years agoNot applicable
Power Query - Insert a new row summing row values for addition columns
Hi, My starting point is: Division Grouping Value Target MValue MTarget North Refund 2 4 5 6 N...
- Anonymous7 years ago
Please take a look at the attached file to see all the detailed steps, but here's a quick overview:
- Load the data ( I just took what you posted here, but had to some manual splitting, so the first 2/3 of the applied steps are that)
- Duplicate the querry ( I named it GP_Grouping)
- Filter out rows you dont want to sum ( though probably better to say the rows you want to keep, but for now it just takes the rows where grouping <> Cash"
- Grouped the rows by Division, and then added columns for the Sum of the four columns
- Add a custom column with the name Grouping and the values GP
- Go back to the original table and append it with the GP_Grouping table
Final Table:
Here's the file:
Anonymous
7 years agoNot applicable
Please take a look at the attached file to see all the detailed steps, but here's a quick overview:
- Load the data ( I just took what you posted here, but had to some manual splitting, so the first 2/3 of the applied steps are that)
- Duplicate the querry ( I named it GP_Grouping)
- Filter out rows you dont want to sum ( though probably better to say the rows you want to keep, but for now it just takes the rows where grouping <> Cash"
- Grouped the rows by Division, and then added columns for the Sum of the four columns
- Add a custom column with the name Grouping and the values GP
- Go back to the original table and append it with the GP_Grouping table
Final Table:
Here's the file:
- Anonymous7 years agoNot applicable
Thanks Anonymous Much appreciated.