I am having an issue with summing two different columns based of the item id with a subquery. I want to get the sum of Profit and Qtyship from 7/1/16 onward to attach to each Invtid per ShipDate. I appreciate the help thanks in advance!

Current:

```
ShipDate   InvtID      Qtyship   Profit
7/19/2016  Item101         4     $20
7/21/2016  Item101         5     $25
7/1/2016   Product411     11     $44
7/1/2016   Product411     14     $56

```

Here is what it should look like:

```
ShipDate   InvtID      Qtyship   Profit   Total Qtyship   Total Profit
7/19/2016  Item101         4     $20          9                $45
7/21/2016  Item101         5     $25          9                $45
7/1/2016   Product411     11     $44          25               $100
7/1/2016   Product411     14     $56          25               $100

```

The query code:

```
select h.shipdate, h.invcnbr,
l.invtid, l.slsprice, l.qtyship, l.totcost,
l.slsprice*l.qtyship as revenue,
(l.slsprice*l.qtyship)-l.TotCost as Profit
from opsshipper h
join opshipline l on h.shipperid=l.shipperid where h.invcdate>='7/1/2016' 
and l.qtyship<>0 and l.slsprice>0 order by h.invcdate,l.invtid 

```