I need some help regarding a Month selection in my qvw file.
In my file, there are four filters (Year,Month, Time Period and Measure) available. Please have a look at the below two screenshots. The Requirement is, if I select Year (e.g 2015) , Month(Mar), Time Period (Mat) and Measure (Stand. Unit) then my chart should show latest 12 Months' Market Share.
But the Chart Dimension is not a Date Column (e.g 201503, 201405 etc.).
What should be the expression? currently this expression is used:
As you can see that, this is for monthly periods, and in the below expression, there are Year and Quarter selected, but we have 4 filters in our scenario. Year, Month, TimePeriod and Measure. So, what should be the selections there?