Driving cross table using drop down

I have a drop down with values as Weekly, Monthly, Yearly which would drive cross table data based on the selection but can we change the number of columns/values to be seen on the vertical axis or horizontal when the selection is made in dropdown.

Like, when weekly is selected then vertical axis column "Region" should show A, B, C, D and when monthly is selected it should show A, B, C, D, E, F.

(1) Answer

Login