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