Forum Discussion
Solved
Group subsequently added columns dynamically
Hello, is it possible to group subsequently added columns dynamically? Thanks in advance. C.
Let's try this:
Go to the Query Editor, select the "static" column(s) (that should be always there no matter what), right click, Unpivot Other Columns.
Thanks for yout time an effort I'm a total beginner.
Is it in the report view possible to define the groupby action without specifing every single column? I just want to group all columns in a table by one.
Maybe this pseudo code makes it easier to understand what I want to do.
Table = GROUPBY(
Table,
Table[GroupByThisColumn],
Dynamic Name for new Columns(maybe column count +1 or sth),
SUMX(
CURRENTGROUP(),
* (wildcard for all columns in the table)
)
)
Let's try this:
Go to the Query Editor, select the "static" column(s) (that should be always there no matter what), right click, Unpivot Other Columns.
I got it, thanks Svalen.