我如何修复此报告，以便我将“私人餐厅”排在第1级，第2级，第3级的一行中。 [英] How can I fix this report so I have 'private placememts' in one row with level 1, level 2, Level 3.

问题描述

SELECT DISTINCT 
  [NOTES 2] AS Notes2, GROUPINGFORFS, InvestmentTypeDescforFS, FAS157Level, 
  CASE WHEN FAS157Level = 'level 1' THEN SUM(MarketValueBaseUpdated) END AS Expr1, 
  CASE WHEN FAS157Level = 'level 2' THEN SUM(MarketValueBaseUpdated) END AS Expr2, 
  CASE WHEN FAS157Level = 'level 3' THEN SUM(MarketValueBaseUpdated) END AS Expr3
FROM         OutputAWSOIDetailreport
WHERE     (LoadID = @loadID)
GROUP BY [NOTES 2], GROUPINGFORFS, InvestmentTypeDescforFS, FAS157Level

Notes2	GROUPINGFORFS	Investment Type Descfor FS	Level 1	Level 2	Level 3	Grand Total
Asset	Derivative contracts	Equity Call Options	$74,249			
	Derivative contracts	Equity Swaps		$1,987,764		
	Derivative contracts	Fully Funded Equity Swaps	$6,342,552			
	Investments in private investment companies, at fair value	Private Placements	$1,650,000			
	Investments in private investment companies, at fair value	Private Placements			$3,559,333	
	Investments in securities, at fair value	American Depository Receipts	$13,886,375			
	Investments in securities, at fair value	Common Stocks	$194,545,783			
	Investments in securities, at fair value	Common Stocks			$0	
	Investments in securities, at fair value	Corporate Bond Fixed Rates		$5,633,739		
	Investments in securities, at fair value	Global Depository Receipts	$27,163			
	Investments in securities, at fair value	Real Estates	$1,629,094			
	Asset   Total:
		$218,155,215	$7,621,503	$3,559,333	
						
Liability	Derivative contracts	Equity Swaps		($3,367,082)		
	Investments in securities, at fair value	American Depository Receipts	($151,015)			
	Investments in securities, at fair value	American Depository Receipts			$0	
	Investments in securities, at fair value	Common Stocks	($38,890,945)			
	Investments in securities, at fair value	Common Stocks		($165,805)		
	Investments in securities, at fair value	Common Stocks			$0	
	Investments in securities, at fair value	Exchange Traded Funds	($4,552,463)			
	Liability   Total:
		($43,594,422)	($3,532,887)	$0

推荐答案

74,249
衍生工具合约股权掉期

74,249 Derivative contracts Equity Swaps

1,987,764
衍生合约全额融资股权掉期

1,987,764 Derivative contracts Fully Funded Equity Swaps

6,342,552
私募投资公司的投资，按公允价值私募配售

6,342,552 Investments in private investment companies, at fair value Private Placements

这篇关于我如何修复此报告，以便我将“私人餐厅”排在第1级，第2级，第3级的一行中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！