添加汇总行2(Power Query)
问题:为数据添加汇总行
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
汇总 = Table.InsertRows(源,7,{Record.FromList(List.Transform({0..3},(x)=> List.Transform(Table.ToColumns(源), each List.Sum(_)){x}), Table.ColumnNames(源))})
in
汇总