chart dimensions

[#1]

Hi,

i have a chart whose dimension consists of month year and category.
i have month year and category on list box as well.

i need that on the click on any value in month year list box
the chart should have start week as its dimension and should show the

weeks of the selected month.

How do i get that?

i appreciate any help.

Regards,

Urmi

[kaushiknsolanki · Accepted solution]

Hi,

     You can include one more dimension i.e Week in your chart and you can specify the Enable condition on that.

     So logically you can say when every there is anything selected in MonthYear list box it shold enable the dimension.

     The enable expression will be.

     =if(getselectedcount(MonthYear)>0,1,0)

Regards,

Kaushik Solanki

[er_mohit]

using getcurrentselection() function you get it