Hello Everyone !!
I need help on how to hide and show columns based on the user selection. My scenario is I have 4 radio buttons in the list page for different time frames, say like one radio button for 3months , one radio button for 6 months ,one button for 12 months and another one for total 12 months. So based on the user selection the list report should should display the output report to that particular time frame. If I select 3 months radio button I should be able to see only 3 months data, select 6 months radio button I should see only 6 months data and same for other 2 radio buttons. I tried some ways but couldn't able to find the solution.
I attached a file to show how the time frames will look. If anyone provide a solution for this scenario with a step by step procedure that will be really helpful for me.
Wouldn't you want to use a detail filter to filter on the prompt selection and display the time frames that you only need? It would decrease performance if you're querying the complete 12 months of data for a 3 month selection and then hiding columns.