如图如代码,以前我的表中没有“部门”这一列,代码如下:
If e.DataCol.name = "年度" OrElse e.DataCol.name = "设计师" Then
If e.DataRow.Isnull("年度") = False AndAlso e.DataRow.Isnull("设计师") = False Then
Dim filter As String = "设计师 = '" & e.DataRow("设计师") & "'"
For i As Integer = 1 To 12
Dim d As Date = new Date(val(e.DataRow("年度")), i, 1)
Dim sum As Integer = DataTables("峰和设计部").compute("sum(签单金额)", filter & " and 事件日期 >= #" & d & "# and 事件日期 < #" & d.addmonths(1) & "#")
e.DataRow("M" & i) = sum
Next
Else
For i As Integer = 1 To 12
e.DataRow("M" & i) = Nothing
Next
End If
End If
现在添加了“部门”列,原被统计表有“设计师”以及“业务员”两例,如何分开统计?
此主题相关图片如下:qq截图20171016144310.jpg
[此贴子已经被作者于2017/10/16 14:47:49编辑过]