用透视表做进销存报表

进销存

查询日期 2010-05-01 数据 一级分类 B-1 B-2 B-3 B-4 B-5 B-6 B-7 B-8 B-9 B-10 B-11 B-12 总计 二级分类 名称 C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 C-9 C-10 C-11 C-12 A-1 A-2 A-3 A-4 A-5 A-6 A-7 A-8 A-9 A-10 A-11 A-12 型号 1-1 1-2 1-3 1-4 1-5 1-6 1-7 1-8 1-9 1-10 1-11 1-12 期初数量 60 60 60 60 60 60 60 60 60 61 30 30 661 期初金额 12,480.00 6,600.00 7,680.00 13,080.00 10,080.00 17,280.00 8,880.00 8,280.00 11,580.00 10,736.00 4,800.00 5,790.00 117,266.00 调入数量 10 10 10 10 10 10 10 10 10 10 10 10 120 调入金额 2,080.00 1,100.00 1,280.00 2,180.00 1,680.00 2,880.00 1,480.00 1,380.00 1,930.00 1,760.00 1,600.00 1,930.00 21,280.00 20 调出数量 10 10 调出金额 2,080.00 1,100.00 3,180.00

查询日期2010-05-01

进销存

销售数量 10 10 10 10 10 10 10

销售金额 2,050.00 1,060.00 1,280.00 2,180.00 1,680.00 2,880.00 1,480.00 -

库存数量 50.00 50.00 60.00 60.00 60.00 60.00 60.00 70.00 70.00 71.00 40.00 40.00 691.00

库存金额 10,400.00 5,500.00 7,680.00 13,080.00 10,080.00 17,280.00 8,880.00 9,660.00 13,510.00 12,496.00 6,400.00 7,720.00 122,588.21

70

12,610.00