添加汇总行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
    汇总

 

posted @ 2022-08-13 17:24  熬肥妖  阅读(455)  评论(0编辑  收藏  举报