select 2016 as year, 123 SalesVolume,333 TicketVolume,20160104 DateKey
union all
select 2016,223,343,20160105
union all
select 2016,323,121,20160106
union all
select 2016,234,909,20160107
union all
select 2016,997,324,20160108
union all
select 2016,434,223,20160109
union all
select 2016,231,324,20160110
union all
select 2015,908,976,20150105
union all
select 2015,347,976,20150106
union all
select 2015,323,766,20150107
union all
select 2015,763,978,20150108
union all
select 2015,678,677,20150109
union all
select 2015,665,666,20150110
union all
select 2015,324,345,20150111
3 个回复
悟 - 取是能力,舍是境界 2016-03-15 回答
赞同来自: 郑大鹏
下面是实现步骤,可能和你的最终实现有差异,不过道理是这样一样道理。
Vicky - QlikView , QlikSense , 微软BI 2016-03-14 回答
赞同来自:
这种方式是否满足你的需求呢?
otzibo - Good good study, day day up. 2016-03-15 回答
赞同来自: