Forum Discussion
Getting Distinct Row WRT ID by Summing multiple category values
Don't think you need to use M code, you can just the UI. Click on the ID column, choose the Transform section of the ribbon and choose Group By. You can then specify which column you want to aggregate and how you want to do it - sum, count etc.
Hi johnt75 ,
can you please help me out with the M Code required after Group by
I m planning to create a new column after group by which will have the sum value of each category and then using distinct i can get rid of duplicates.
So need help for the required M Code after Group by
Thank you
Don't think you need to use M code, you can just the UI. Click on the ID column, choose the Transform section of the ribbon and choose Group By. You can then specify which column you want to aggregate and how you want to do it - sum, count etc.
Thank you for the quick response and for the Solution