问题:为数据添加汇总行
![](https://img.laitimes.com/img/_0nNw4CM6IyYiwiM6ICdiwiI0gTMx81dsQWZ4lmZf1GLlpXazVmcvwFciV2dsQXYtJ3bm9CX9s2RkBnVHFmb1clWvB3MaVnRtp1XlBXe0xCMy81dvRWYoNHLwEzX5xCMx8FesU2cfdGLwMzX0xiRGZkRGZ0Xy9GbvNGLpZTY1EmMZVDUSFTU4VFRR9Fd4VGdsYTMfVmepNHLrJXYtJXZ0F2dvwVZnFWbp1zczV2YvJHctM3cv1Ce-cmbw5SN0YTM2gTZ0gzN3ETZzgjMzYzX5UTMwgTM5EzLclDMyIDMy8CXn9Gbi9CXzV2Zh1WavwVbvNmLvR3YxUjLyM3Lc9CX6MHc0RHaiojIsJye.png)
加载数据表PQ,命名为“表1”
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
降级的标题 = Table.DemoteHeaders(源),
追加的查询 = Table.Combine({降级的标题, 表2}),
提升的标题 = Table.PromoteHeaders(追加的查询),
更改的类型 = Table.TransformColumnTypes(提升的标题,{{"数据1" , Int64.Type}, {"数据2" , Int64.Type}, {"数据3" , Int64.Type}, {"数据4" , Int64.Type}})
in
更改的类型
加载同表数据表PQ,命名为“表2”
let
源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
转列 = Table.ToColumns(源),
转换为表 = Table.FromList(转列, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
求和 = Table.AddColumn(转换为表, "求和", each List.Sum([Column1])),
删除的列 = Table.RemoveColumns(求和,{"Column1"}),
转置表 = Table.Transpose(删除的列)
in
转置表