做出Excel的图形FineBI显示

DECLARE @week1 int
DECLARE @week2 int
DECLARE @week3 int
DECLARE @week4 int
DECLARE @week5 int
DECLARE @week6 int
DECLARE @type VARCHAR(100)

SET @week1=3
SET @week2=4
SET @week3=5
SET @week4=6
SET @week5=7
SET @week6=8
SET @type='99-%'
SELECT SUM(heji) AS BNyingshou ,SUM(snysh) AS WNyingshou,SUM(dqys) AS DQyushou,SUM(sjxj) AS DQsh FROM

--SELECT SUM(heji) AS BNyingshou FROM
(
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week1 AND srdl LIKE @type
UNION ALL
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week2 AND srdl LIKE @type
UNION ALL
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week3 AND srdl LIKE @type
UNION ALL
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week4 AND srdl LIKE @type
UNION ALL
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week5 AND srdl LIKE @type
UNION ALL
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=@week6 AND srdl LIKE @type
) AS test

SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=3 AND srdl LIKE '2-%'
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=3 AND srdl LIKE '3-%'
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=3 AND srdl LIKE '4-%'
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=3 AND srdl LIKE '5-%'
SELECT dqyssh+bnysh AS heji,snysh,dqys,sjxj FROM [ecp].[dbo].[formtable_main_758_dt1] WHERE mainid=3 AND srdl LIKE '99-%'

你好，我是有问必答小助手。为了技术专家团更好地为您解答问题，烦请您补充下（1）问题背景详情，（2）您想解决的具体问题，（3）问题相关代码图片或者报错信息。便于技术专家团更好地理解问题，并给出解决方案。

您可以点击问题下方的【编辑】，进行补充修改问题。