这种东西,在excel中实现不难,就是要注意时间的区别,SQL语句如下:
- transform sum(订单)
- select 区别
- from
- (
- select
- 日期,
- iif(日期>=dateadd("ww",datediff("ww",0,date())-1,0)+2,"1.本周","1.上周") as 区别,
- 部门,
- 订单
- from [明细$A:C]
- where 日期 between dateadd("ww",datediff("ww",1,date())-1,1)+1 and date()
- union all
- select
- 日期,
- iif(日期>=dateserial(year(dateadd("m",-1,date())),month(dateadd("m",-1,date())),25),"2.本月","2.上月") as 区别,
- 部门,
- 订单
- from [明细$A:C]
- where 日期 between dateserial(year(dateadd("m",-2,date())),month(dateadd("m",-2,date())),25) and dateserial(year(date()),month(date()),24)
- )
- group by 区别
- pivot 部门
复制代码
|