Dim b As New GroupTableBuilder("占比统计表",DataTables("person"))
b.Groups.AddDef(zd(TongJi) , TongJi)
For Each c As String In cs.split(",")
Dim val As Integer = zd2(c)
If val = 50 Then
b.Totals.AddExp("人数_60以下"," Case When age < 60 Then 1 Else 0 End ",AggregateEnum.Count)
Else If val = 90
b.Totals.AddExp("人数_90以上"," Case When age >= 90 Then 1 Else 0 End ")
MessageBox.Show("yy")
Else
b.Totals.AddExp("人数_& c &", " Case When age >=val And age < val+10 Then 1 Else 0 End ")
MessageBox.Show("zz")
End If
Next
t=b.build()
数值分布统计只有一列