Best way to create the below requirement

[kvca11]

Hi Team,

Please help me on below requirement.

I need to give the prompt(year window) option like Year,Quarter and Month and years prompt  as 1-20 and based on the user selection the report should display the result.

If user selects no of years as 10 and year window as month then need to display 120 months of data.
I have 8 measures are there in the report and 20 columns are there.

I have tried by creating the Cross tab and its having the performance issue and could not able to achieve by using cross tab

any suggestions?

thanks
ca11