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...
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    3 years ago

    Anonymous Right click on the Object Column and select Group By

    Then specify the Operation as Sum and choose the Qty column

AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

Anonymous Right click on the Object Column and select Group By

Then specify the Operation as Sum and choose the Qty column