drop table if exists #WorkingTable

SELECT IDENTITY(int, 1, 1) as RowNumber , TradeType,	cAST(TradeDate as DateTime) as TradeDate
, CAST(Amount AS float) as Amount
, case when TradeType = 'Purchase' THEN 
	Row_NUmber () over (partition by TradeType order by TradeDate ) 
	ELSE NULL
	END PoolId
into #WorkingTable
FROM (
VALUES 
('Purchase',	'1/31/2020',13234589.20)
,('Sale',	'1/31/2020',	1000000.00)
,('Sale',	'1/31/2020',	1000000.00)
,('Sale',	'1/31/2020',	1000000.00)
,('Sale',	'1/31/2020',	1234589.20)
,('Sale',	'1/31/2020',	1000000.00)
,('Sale',	'1/31/2020',	1500000.00)
,('Sale',	'1/31/2020',	1000000.00)
,('Purchase',	'2/28/2020',	2000000.00)
,('Sale',	'2/28/2020',	1000000.00)
,('Sale',	'2/28/2020',	1000000.00)
,('Sale',	'3/6/2020',		2750000.00)
,('Purchase',	'3/11/2020',	2000000.00)
,('Purchase',	'3/12/2020',	2000000.00)
,('Sale',	'3/12/2020',	2000000.00)
,('Purchase',	'3/17/2020',	3000000.00)
,('Sale',	'3/17/2020',	1000000.00)

) AS vtable 
( TradeType,	TradeDate,	Amount)

;WITH cte as (
select *
,  CASE WHEN TradeType ='Purchase' THEN 
		cast(RowNumber as varchar) + '_Purchase'
		ELSE NULL
	END	as Pivot_Purchase_left
, CASE WHEN TradeType ='Sale' THEN 
		Amount * -1
		ELSE NULL
	END	as Sale
from #WorkingTable
)
select *
from 
(
  select *
  from cte
) src
pivot
(
  sum(Amount)
  for Pivot_Purchase_left in ([1_Purchase], [2_Purchase], [3_Purchase], [4_Purchase], [5_Purchase])
) piv
order by TradeDate