Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to get the table working

Hi, 

 

In my power query i would like to to have the sum of all values in the Qty column and only showing one row for each obeject in the object column.

 

Ex: 815361 = 6

 

Any suggestions how to do it?

BR Patrik

 

  • Anonymous Right click on the Object Column and select Group By

    Then specify the Operation as Sum and choose the Qty column

1 Reply

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion

    Anonymous Right click on the Object Column and select Group By

    Then specify the Operation as Sum and choose the Qty column