Option 1:

Orders:

LOAD EmployeeID,

          Year,

          Sales,

          ....

FROM Orders;

Left Join (Orders)

LOAD EmployeeID,

    Year,

    Sum(Sales)

Resident Orders

Group By EmployeeID, Year;

Option 2:

Orders:

LOAD EmployeeID,

          Year,

          AutoNumber(EmployeeID&Year, 'Total_Sales_Year') as Key,

          Sales,

          ....

FROM Orders;

Total_Sales_Year:

LOAD Key,

   Sum(Sales)

Resident Orders

Group By Key;