Dim g As New CrossTableBuilder("统计汇总", DataTables("绩效计划表"))
g.Caption = "统计汇总"
g.HGroups.AddDef("年度")
g.HGroups.AddDef("季度")
g.VGroups.AddDef("分管领导")
g.Totals.AddDef("计划权重", "计划权重")
g.Totals.AddDef("考核权重", "考核权重")
g.Totals.AddDef("自评得分", "自评得分")
g.Subtotal = True
g.Build()
MainTable = Tables("统计汇总")
公式如下。运行后自动建议统计汇总表,统计没问题,但每列的宽度都很大,过大,列数多了每次都需要手工调整列宽。能否在公示中直接定义列宽