Forluma based on column order

[petros21]

Hi, 

I want to do some maths in a new column based on the order of the columns.

Based on my query the headers could have different name.   

For example I want to calculate --> 3. column + 4. column 

Thanks in advance 

/Petros 

[Par_O]

@petros21 Can you expand a little on this? Do you want to add values from two or more columns based on the names of the columns? 

[petros21]

The headers of the last 3 Columns are changing every month based on my select (--> last 3 months).

I want to calc the average of the last 3 months. 

Following worked last month, but of course not this.

Reaseon: the last three columns are from this month 

Thanks in advance 

[gautiergodard]

Hello @petros21 

If I understand your problem correctly, here is one way you could do this:

Hope this helps!

[binuacs]

@petros21 One way of doing this with the Dynamic Select tool

[petros21 · Accepted solution]

Thx guys. It was easy - at the end :) .... 

I used the dynamic renaming tool