Group By: Not Working

Hi expert! I have one problem that i think people from this community can help me with 😊

Problem:

I want to group a value column based on certain columns. But when I use function grouped by, it seems doesn't worked. Below are the examples:

Based on this image, I want to group columns ARTICLE, PRD_ORDERID, and PRODUCTION_DATE to get sum of SF (square feet). As we can see in the red square I have same ARTICLE, same PRD_ORDERID & CUSTOMER but different PALLET_NUMBER. So i want to ignore PALLET_NUMBER because I just wanted to know how many SF have been produced on certain date, for a certain order id & article number.

Result:

Below is the result that i got from grouped by function. It still shows multiple rows for the same PRD_ORDERID & PRODUCTION_DATE.

Desired output:

My desired output is for PRD_ORDER = 4477549 and PRODUCTION_DATE = 27/6/2020, I just want one row that shows sum of SQFT for the particular order & date.

Any idea why this is happening? Thanks in advance!