it can be done by tree view list box aur using multibox also.
Filter of Year and Month.qvw 177.2 K
Hi Sanchit, You can have a drop down of Year and Month in a list box with "Always select one value" enabled.
use a inline table for this.
load * inline
In your chart have your year and month dimensions, but enable Conditional. and then have a condition like this.
SubstringCount(Dimname,'Year') > 0 in your year dimension
SubstringCount(Dimname,'Month')>0 in your month dimension
and well that should be it.
a bit confused if you select Year first that means you are interested in that particular year then obvious you will go for months...
why you want first Year option then again Year and Month Option.
if i select 2012 among 2006 - 2012.
Months options which I should get : Jan, Feb & Mar
Years options which YOU want ???? it obvious will be 2012 isn't it ?