加一个平均值的行
Dim t As Table = Tables("库存")
Dim g As SubtotalGroup
Dim g1 As SubtotalGroup
t.SubtotalGroups.Clear()
t.GroupAboveData = False
t.TreeVisible = False
g = New SubtotalGroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "产品"
g.TotalOn = "数量,金额"
g.Caption = "{0} 小计"
t.SubtotalGroups.Add(g)
g1 = New SubtotalGroup
g1.Aggregate = AggregateEnum.Average
g1.GroupOn = "产品"
g1.TotalOn = "单价"
g1.Caption = "{0} 平均"
t.SubtotalGroups.Add(g1)
g = New SubtotalGroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "*"
g.TotalOn = "数量,金额"
g.Caption = "总计"
t.SubtotalGroups.Add(g)
t.Subtotal()