请教一下透视表的进销存的问题

tianyonghuai

请教一下透视表的进销存的问题，如附件
当我插入计算项“结存”后，透视表结存变了，每个编码本来只对应一个品名，现在变成一个编码对应了N个品名，是怎么回事呢？

penghaifeng

数据项目太多的话，不适宜用计算项，可考虑用公式中的计算字段。
具体做法可搜索此论坛中相关贴子。

tianyonghuai

重新做了一次，计算公式，还是出错~~~~~~

tianyonghuai

是SQL语句出错了吗：
SELECT 仓库,客户厂商,料号,品名,期初数量,期初金额,0 AS 出库数量,0 AS 出库金额,0 AS 入库数量,0 AS 入库金额 FROM [材料期初库存$] UNION ALL
SELECT 仓库,客户厂商,料号,品名,入库数量,入库金额,0 AS 出库数量,0 AS 出库金额,0 AS 期初数量,0 AS 期初金额 FROM [材料入库明细表$] UNION ALL
SELECT 仓库,客户厂商,料号,品名,出库数量,出库金额,0 AS 入库数量,0 AS 入库金额,0 AS 期初数量,0 AS 期初金额 FROM [材料出库明细表$]

penghaifeng

语句出错了！三条语句中字段顺序要一致才行，如下面写法：
SELECT 仓库,客户厂商,料号,品名,期初数量,期初金额,0 AS 出库数量,0 AS 出库金额,0 AS 入库数量,0 AS 入库金额 FROM [材料期初库存$] UNION ALL
SELECT 仓库,客户厂商,料号,品名,0 AS 期初数量,0 AS 期初金额,0 AS 出库数量,0 AS 出库金额,入库数量,入库金额  FROM [材料入库明细表$] UNION ALL
SELECT 仓库,客户厂商,料号,品名,0 AS 期初数量,0 AS 期初金额,出库数量,出库金额,0 AS 入库数量,0 AS 入库金额 FROM [材料出库明细表$]

tianyonghuai

哦，谢谢！！