Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Please take a look at the attached file to see all the detailed steps, but here's a quick overview:

    1. 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)
    2. Duplicate the querry ( I named it GP_Grouping)
    3. 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"
    4. Grouped the rows by Division, and then added columns for the Sum of the four columns
    5. Add a custom column with the name Grouping and the values GP
    6. Go back to the original table and append it with the GP_Grouping table

     

    Final Table:

     

    Here's the file:

    https://1drv.ms/f/s!AoQIGRpzoxRHgbxBe-I0NdRAmrMPhg