Forum Discussion
Solved
group by variable column name
Hi all, I try to achieve a report with a 'group by' which uses flexible column names. The column names are handed over from another table which is filled with a different manual edited name, ...
List.Sum(Table.Column(_,#"para_name"))
Hi, Sammy_home ;
I'm a little confused, are you trying to dynamically sum Testname? Is testname from another table? Can you provide a simple file and a display of the results you wish to output?
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wdx223_Daniel perfect thanks!!!
It is exactly what I've been trying to achieve.
The output looks now like following to reply to you question v-yalanwu-msft