Dynamic Field selection based on month selection

[alt_tush]

Hi All,

I have below table.

My requirement is if i select the any date from datetime tool from any month then only only those columns proceed where the till month selected from datetime.

If i select month Feb then only data proceed or (field select) from mt_ytd_jan till mt_net_feb fields process.

If i select month Mar then only data proceed or (field select) from mt_ytd_jan till mt_net_mar fields process.

if i select month Aug then only data proceed from mt_yt or (field select) from mt_ytd_jan till mt_net_jul fields process and like wise

Input :-

cd_category	cd_type_cur	cd_nat_data	mt_ytd_jan	mt_net_jan	mt_ytd_feb	mt_net_feb	mt_ytd_mar	mt_net_mar	mt_ytd_apr	mt_net_apr	mt_ytd_may	mt_net_may
ACTUAL2020	PERIODICAL	ABC	10	20	30	40	50	60	70	80	90	100
ACTUAL2020	LOCAL	PQR	20	30	40	50	60	70	80	90	100	110
ACTUAL2020	HISTORICAL	XYZ	30	40	50	60	70	80	90	100	110	120
ACTUAL2021	PERIODICAL	ABC	40	50	60	70	80	90	100	110	120	130
ACTUAL2021	LOCAL	PQR	50	60	70	80	90	100	110	120	130	140
ACTUAL2021	HISTORICAL	XYZ	60	70	80	90	100	110	120	130	140	150

Please suggest.

Thank you in advanced.

[apathetichell]

Make an app with a date tool/connected to a filter.

It should be possible to do this without transpose/crosstab via dynamic select but I'm still working on getting my formula down.  I'll update with a second version - but this one works via transpose/filter/crosstab.

[apathetichell]

version with dynamic select.

[alt_tush]

Hi apathetichell,

Thank you so much for your quick response.

I have checked the workflow but it gives me selected month fields only.

My expectation is if i select April then it should be select all fields from Jan till Apr instead of giving only Apr month field.

If i select month feb then i should select the fields from Jan till Feb likewise.

I hope you understand my requirement.

Thanks again 🙂

[apathetichell]

sorry - just noticed - you wanted the range up to month. Here it is.

[apathetichell]

Yeah - fixed it in the non-dynamic version... Off to try to fix it in the dynamic select one...

[apathetichell · Accepted solution]

this version should work for dynamic select tool...

[alt_tush]

Hi apathetichell,

It works. Thank you Thank you so much for your quick response.

[apathetichell]

glad to hear and thanks!