Select Column Based on Current Month

[Bharkavi]

Hello everyone,

I have the following table 

Name	Jan'25	Feb'25	Mar'25	Apr'25
Alice	1	4	7	10
Bob	2	5	8	11
Peter	3	6	9	12

I have created a formula to return the current month. I want to dynamically select the column that matches this current month formula. Eg: Current month = Feb then output is column "Feb'25" and to sum the values under this column. 

Does anyone know how to do this in alteryx?

[PangHC]

dynamic rename to rename that column to "Current month" then use for summarize then do the rest as usual.

[Bharkavi]

Thanks! 

Just to clarify - Which column should I rename to the Current Month?

[Qiu · Accepted solution]

@Bharkavi 
I think we can do as below.
One is using the combination of Transpose and Cross Tab, another is the Dynamic Select but a bit length.