以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 统计合并问题? (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=188981) |
-- 作者:lin98 -- 发布时间:2023/11/3 11:21:00 -- 统计合并问题? 代码一 Dim g As New CrossTableBuilder("统计表1", DataTables("汇总窗口_Table1")) g.HGroups.AddDef("供方") g.VGroups.AddDef("采购日期", DateGroupEnum.Year, "{0}年_数量") g.Totals.AddDef("数量", "数量") g.HorizontalTotal = True g.VerticalTotal = True g.HorizontalProportion = True g.VerticalProportion = True Tables("汇总窗口_Table2").DataSource = g.BuildDataSource() 代码二 Dim g As New CrossTableBuilder("统计表2", DataTables("汇总窗口_Table1")) g.HGroups.AddDef("供方") g.VGroups.AddDef("采购日期", DateGroupEnum.Year, "{0}年_金额") g.Totals.AddDef("金额", "金额") g.HorizontalTotal = True g.VerticalTotal = True g.HorizontalProportion = True g.VerticalProportion = True Tables("汇总窗口_Table2").DataSource = g.BuildDataSource() \' 如何将数量和金额合并一起统计? |
-- 作者:有点蓝 -- 发布时间:2023/11/3 11:28:00 -- Dim g As New CrossTableBuilder("统计表2", DataTables("汇总窗口_Table1")) g.HGroups.AddDef("供方") g.VGroups.AddDef("采购日期", DateGroupEnum.Year) g.Totals.AddDef("数量", "数量")g.Totals.AddDef("金额", "金额") ……
|