This discussion is archived
1 Reply Latest reply: Jul 18, 2013 1:28 AM by 937325 RSS

Quarter format filter problem??

937325 Explorer
Currently Being Moderated

Hi Gurus,

 

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.

 

 

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points