Picking current month

[kauser]

hello, 

how to pick first month column only based on following data 

Input Data 

Item	August	August1	September	October	November
A	4658	345435	67889	234325	687758

Expected Output- 

August

4658

i have tried this formula below but didn't work- 

[Name] IN ('Item')
OR
[Name] = ToString(DateTimeMonth(DateTimetoday()))

Thank you 

Kauser 

[alexnajm]

How do you want it to select august when the date today is in January?

[kauser]

then can we setup a formula to select the second column only 

[alexnajm · Accepted solution]

Then you can use a Dynamic Select where ([FieldNumber] = 2) (in addition to [Name] IN ('Item') )

[caltang · Accepted solution]

Your formula:

[Name] IN ('Item')
OR
[Name] = ToString(DateTimeMonth(DateTimetoday()))

Does not select Headers - it works on Rows. What @alexnajm is better as it selects based on Headers.

Alternatively, you can use a Record ID + Transpose to get your data set, then implement an analytic app by adding interface layers on your tools then adding a Cross Tab to get back your answer - this is the most dynamic way and allows end users to change selections each time.