怎样在SSRS中同时出现柱状图和线条图

0
类似于
SQL:

SELECT CAST('2009-01-01' AS date) AS SalesDate, CAST(54995.21 AS money) AS Sales, CAST(77854.21 AS money) AS Nums
UNION SELECT CAST('2009-01-05' AS date) AS SalesDate, CAST(64499.04 AS money) AS Sales, CAST(34335.21 AS money) AS Nums
UNION SELECT CAST('2009-02-11' AS date) AS SalesDate, CAST(37821.79 AS money) AS Sales, CAST(67555.21 AS money) AS Nums
UNION SELECT CAST('2009-03-18' AS date) AS SalesDate, CAST(53633.08 AS money) AS Sales, CAST(54995.21 AS money) AS Nums
UNION SELECT CAST('2009-04-23' AS date) AS SalesDate, CAST(24019.3 AS money) AS Sales, CAST(54995.21 AS money) AS Nums
UNION SELECT CAST('2009-05-01' AS date) AS SalesDate, CAST(93245.5 AS money) AS Sales, CAST(33445.21 AS money) AS Nums
UNION SELECT CAST('2009-06-06' AS date) AS SalesDate, CAST(55288.0 AS money) AS Sales, CAST(97655.21 AS money) AS Nums
UNION SELECT CAST('2009-06-16' AS date) AS SalesDate, CAST(68733.5 AS money) AS Sales, CAST(22345.21 AS money) AS Nums
UNION SELECT CAST('2009-07-16' AS date) AS SalesDate, CAST(24750.85 AS money) AS Sales, CAST(44583.21 AS money) AS Nums
UNION SELECT CAST('2009-08-23' AS date) AS SalesDate, CAST(43452.3 AS money) AS Sales, CAST(85789.21 AS money) AS Nums
UNION SELECT CAST('2009-09-24' AS date) AS SalesDate, CAST(58656. AS money) AS Sales, CAST(27907.21 AS money) AS Nums
UNION SELECT CAST('2009-10-15' AS date) AS SalesDate, CAST(44583. AS money) AS Sales, CAST(34905.21 AS money) AS Nums
UNION SELECT CAST('2009-11-21' AS date) AS SalesDate, CAST(81568. AS money) AS Sales, CAST(54885.21 AS money) AS Nums
UNION SELECT CAST('2009-12-15' AS date) AS SalesDate, CAST(45973. AS money) AS Sales, CAST(64995.21 AS money) AS Nums
UNION SELECT CAST('2009-12-26' AS date) AS SalesDate, CAST(96357. AS money) AS Sales, CAST(54995 AS money) AS Nums
UNION SELECT CAST('2009-12-31' AS date) AS SalesDate, CAST(81946. AS money) AS Sales, CAST(45973 AS money) AS Nums


有三个字段,SalesDate, Sales,Nums.需求是以SalesDate作为类别,以Sales作为柱状图的计算,Nums作为线状图

应该如何做呢,谢谢
已邀请:
0

梁勇 - 天道酬勤、上善若水。爱好商业智能 2014-09-23 回答

这个简单了,都先放到柱状图里面,然后点击 Nums 这个度量,右键,更改图表类型,选择 线图形即可,类似于这个 双Y轴的 SSRS 双纵轴图怎么做? http://www.flybi.net/question/531
0

july2008hll 2014-09-23 回答

已经弄出来了,谢谢

要回复问题请先登录注册