Forum Discussion
Solved
Add subtotal Rows
Hi All, I have a data with more than 2k activities in and with a column [Code for Area]. I need to group them by [Code for Area] and add a subtotal rows at the beginning of each group with Gruop ...
NewStep=Table.Combine(Table.Group(PreviousStepName,"Code for Area",{"n",each #table(Table.ColumnNames(_),{{Text.Replace([Code for Area]{0},"-"," Works at Area "),null,List.Sum([Volumes])}})&_)})[n])
Hi kassymov_su ,
Could you tell me if wdx223_Daniel 's suggestion helps you ? If it is, kindly Accept it as the solution. More people will benefit from it.
Best Regards,
Eyelyn Qin