Hi all, I would like to ask if it is possible to perform group by and sum based on the image i have attach below?
As you can see from the image, I have boxed up the PO,Colour to show you all that in the same PO, there will be duplicate colour. However, the colour has difference pounds and yarns weight and the line is difference.
I use this data to create a unmatched query based on the PO and Line so i am thinking if it is possible to group all the same colour together, and sum the pounds and yarns weight? And at the same time, i can still continue to use PO and Line in unmatched query.
Thank you.
As you can see from the image, I have boxed up the PO,Colour to show you all that in the same PO, there will be duplicate colour. However, the colour has difference pounds and yarns weight and the line is difference.
I use this data to create a unmatched query based on the PO and Line so i am thinking if it is possible to group all the same colour together, and sum the pounds and yarns weight? And at the same time, i can still continue to use PO and Line in unmatched query.
Thank you.