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

this version should work for dynamic select tool...

dynamic select month selector.yxwz