Crosstab column hide to previous week

[balaguruvelu]

Hello All,

In crosstab I have displayed the data for 10 weeks. In current week,I have displayed 6 columns, but other than current week I have displayed only 2 columns remaining 4 columns I have to be hide.

week10            week9      week8      week7      week6      week5      week4       week3    week2     week1
col1 col2 col3 col4 col5 col6  col1 col5   col1 col5  col1 col5  col1 col5  col1 col5  col1 col5  col1 col5 col1 col5 col1 col5
data data data data data data  data data   data data  data data  data data  data data  data data  data data data data data data

I have checked  the ways to hide the columns but I did not get the solution. Please share with me do you have any ideas about hide the columns in previous weeks.

Thank you.