Picking current month

Question

hello,

how to pick first month column only based on following data

Input Data

ItemAugustAugust1SeptemberOctoberNovemberA465834543567889234325687758

Expected Output-

August4658

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

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

Thank you

Kauser

alexnajm · Accepted Answer

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

caltang · Accepted Answer

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.