Dyamically get the values based on the prompt selection

[kvchow]

Hi all,

I have the below requirement.
Prompts:

Numofyears : 1,2,3,4,5,6,7,8,9,10
Startyear :Current year by default
unit:Year,quarter,month

If the user selects Number of years as 2 and start year as 2020 and unit as month then need to display the 24 months data.

Is there any way to dynamically change the columns.

It is difficult if user select numofyears as 10 and unit as month then need to dispaly 120 months of data and its a lengthy process

Any ideas?

thanks,
ca11