Forum Discussion
Consolidate by Multiple Criteria
Hello All, I apologize if I have asked too many questions of the community but I think if I could get help with this data set I am working on it would solve most, if not all my problems. Right n...
Hi Anonymous ,
On the query editor you must do the Group by option, then you need to select all the columns that you want to keep like Vendor, Item Number, Po Line and then on the aggregation select Maximum for data and sum for Received quantity on the other columns keep the maximum or minimum since they are equal.
v-lid-msft
Community Support
Community SupportHi Anonymous ,
As additional supplement of @MFelix 's wonderful solution, we can group by like following screenshot :
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared？
Best regards,