多列分类汇总
dt1.AsEnumerable().Where(Function(r) Not (r("产品") Is Nothing) And Not (r("客户") Is Nothing) And Not (r("销售数量") Is Nothing)).GroupBy(Function(r) String.Join(",",New String() {r("产品").ToString(), r("客户").ToString(),r("销售数量").ToString()}))
根据三列分类汇总数据表,
Enumerable.Range(15, dt.ColumnCount - 15).Select(Function(r) dt.Columns(r).ColumnName).ToList() 第15列到之后所有列求和
data_row(col_name)=currentItem.Sum(Function(r) Convert.ToDecimal(r(col_name)))
完整流程: