Need help about group up dynamic data using list

[Anonymous]

Background : I have a reference list containing set of series named "FuturesSeries" which data in the list dynamically change , as you can see below.

I create this list for supporting dynamic data. When I modify my table I can refer to the list instead the value, which will broken the process when the data are changed.

Problem : I tried to group up my table by using a value from the list but its always leading to error and i cant find the way to correct it, here is a original formula if I using the value.

I replace list of series in the formula as i mentioned before ,but its leading to error like this.

Do you have any suggestion for this issue or about combinding group up function with list.

thank for your advice.

[KNP · Accepted solution]

Hi @Anonymous,

I think you need something like the below code...

Table.Group(
  Source,
  GroupColumns,
  List.Transform(FutureSeries, (x) => {x, each List.Sum(Table.Column(_, x)), type number})
)

Replace the Source with your previous step and the GroupColumns with your list of columns to group by and it should work as expected.

I hope this helps.