请教，如何把竖表变横表并求合计及小计？
请教各位老师，如何把以下的abc表，通过编程，变成abd 表，并求合计及小计，谢谢。
CLOSE ALL
CLEAR
SET SAFETY off
CREATE table abc (姓名 c(10), 代码 c(14),数值 n(9,2))
INSERT INTO abc VALUES ( "amy","0101", 1250)
INSERT INTO abc VALUES ("amy","0101L", 250)
INSERT INTO abc VALUES ("amy","0101P", 52)
INSERT INTO abc VALUES ("amy","0101PL", 12)
INSERT INTO abc VALUES ("tony","0101", 1500)
INSERT INTO abc VALUES ("tony","0101L", 260)
INSERT INTO abc VALUES ("tony","0101P", 50)
INSERT INTO abc VALUES ("tony","0101PL", 11)
INSERT INTO abc VALUES ("cici","0401", 900)
INSERT INTO abc VALUES ("cici ","0401L", 300)
INSERT INTO abc VALUES ("cici","0401P", 45)
INSERT INTO abc VALUES ("cici", "0401PL", 15)
INSERT INTO abc VALUES ("mimi", "0401", 800)
INSERT INTO abc VALUES ("mimi","0401L", 200)
INSERT INTO abc VALUES ("mimi", "0401P", 40)
INSERT INTO abc VALUES ("mimi","0401PL", 13)
BROWSE
*abd 表
姓名 0101 0101L 0101P 0101PL 0401 0401L 0401P 0401PL 合计
amy 1250 250 52 12 1564
tony 1500 260 50 11 1821
cici 900 300 45 15 1260
mimi 800 200 40 13 1053
小计 2750 510 102 23 1700 500 85 28 5698
[解决办法]
Sum(IIF(代码='0101',1,0)) As a0101,;其它自行修改
[解决办法]
Sum(IIF(代码='0101',1000000.00,000000000.00)) As a0101
