Try subtotal instead of Advanced Filter.....

Keep the cursor in the First column heading....
Select the entire range of 1044 Rows by pressing Ctrl+A.....

Click Data > Subtotals ....

Give the following options :-

At each change in:- "Location code" - select the column heading...

Use Function:- Sum

Add Subtotal to:- "Column3" give the column 3 heading...

Click ok

Hope this helps u

Regards,
guru