Need to change expression label name according to selection???

[#1]

Hi All,

         In my app having last 3 years,3 Quarter&3 months bar chart. i wrote lable name, legand shows like this

         current Qtr

         prev Qtr

         last prev Qtr

  but it is not good while seeing client he may confuse.

  i need dynamic changes in label name also as per client selections like this:

  2011-2012 Q1

  2011-2012 Q2

  2011-2012 Q3.

  i  tried max function it's working in year&month but not working in qtr because string is there.

Thanks,

Ashok.

[#2]

Hi,

Can you provide a sample application?

Regards,

[Anonymous]

Can you get round the string problem in quarter by testing for Right(Qtr,1) instead ?

Jonathan

[#4]

Hi,

    Please find my attached application.

I need like this format:

Currnt Qtr:2011-2012 Q1

Prev Qtr:2011-2012 Q2

Last prev Qtr:2011-2012 Q3

Currnt Year:2011-2012

Prev Year:2010-2011

Last Prev Year:2009-2010

Thanks,

1. Ashok.

[#5]

Hi,

I tried to implement a solution, it may not be exactly what you need but it may hopefully be helpful.

Pls see the attached file.

Regards,

[SunilChauhan]

=getfieldselction(Yearfieldname)&'-'&getfieldselction(Yearfieldname)&' '&

getfieldselction(quarterfieldname)

hope this helps