|
- select 五大类,类目名称,[6月最低或最高值] as 6月最高值,0 as 6月最低值,0 as 12月最高值,0 as 12月最低值 from[表一$a:d] where [6月最低或最高值]=dmax("[6月最低或最高值]","表一$a:d","五大类='"&五大类&"' and 类目名称='"&类目名称&"'") union select 五大类,类目名称,0 as 6月最高值,[6月最低或最高值] as 6月最低值,0 as 12月最高值,0 as 12月最低值 from[表一$a:d] where [6月最低或最高值]=dmin("[6月最低或最高值]","表一$a:d","五大类='"&五大类&"' and 类目名称='"&类目名称&"'") union select 五大类,类目名称,0 as 6月最高值,0 as 6月最低值,[12月最低或最高值] as 12月最大值,0 as 12月最低值 from[表一$a:d] where [12月最低或最高值]=dmax("[12月最低或最高值]","表一$a:d","五大类='"&五大类&"' and 类目名称='"&类目名称&"'") union select 五大类,类目名称,0 as 6月最高值,0 as 6月最低值,0 as 12月最高值,[12月最低或最高值] as 12月最低值 from[表一$a:d] where [12月最低或最高值]=dmin("[12月最低或最高值]","表一$a:d","五大类='"&五大类&"' and 类目名称='"&类目名称&"'")
复制代码 数据透视表
工作表 .rar
(10.18 KB, 下载次数: 1)
|
|