Group subsequently added columns dynamically

[ChrsH]

Hello,

is it possible to group subsequently added columns dynamically?

Thanks in advance.

C.

[Anonymous]

Please be more specific.

[ChrsH]

Is it possible to define a groupby routine for all columns, so if one add an column in the data source subsequently, the query still works? I need the same aggregation for every column.

My data source is a SharePoint List,

[Anonymous]

Hi again.

Just trying to figure out what you need, why do you need the sum on another column? Why don't you calculate what you need on the report view?

[ChrsH]

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)
		)
)

[Anonymous · Accepted solution]

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.

[ChrsH]

I got it, thanks Svalen.