I have a Quarter prompt with between option and default values are like Q1 2012 and Q4 2012 and values filter based on year values and i selected year values as 2012;2013.
so ideally in report level by default it should display values Q1 2012, Q2 2012, Q3 2012 and Q4 2012.
But its displaying Q1 2012, Q2 2012, Q3 2012 ,Q4 2012, Q1 2013, Q2 2013 as well.
here its filtering on Q1 to Q4 and considering Q1 and Q2 of 2013 values also.
But when i changed the format like 2012 Q1 then the data is filtering appropriately.
But i need Q1 2012 format only. please anyone help me how to achieve this.
please anyone help me on this.