Get sum of one column, max of another in pivot table

I have 4 columns of data.

DateID: integer representing date
HoldingDate: Date and time info
Units: -1, 0, or 1
NetProfit: real number

I want to put this in a pivot table so that I can see the summed NetProfit for a DateID, and see the Units value for the chronologically last HoldingDate value for each DateID.

I've highlighted the values I want in yellow in the attached file to make this more clear. I'm trying to model this problem in a pivot table before recreating in a cube in SQL Server Management Studio.

Thanks for the help!