chart label display by selection

[Anonymous]

Hi Gurus,

I want to display my 3 selections seperated with ':' in chart window titel

Please find the sample xl file

required output format:   2014:Jan:Q1

I have year Field:2014,2015

Yearquarter:14-Q1( need to Bring only Q1 in lable)

Month Year:Jan-14(need to Bring only Month )

Thanks inadvance

[petter]

This should work:

=Min(Year) & ';' & MinString(Month(Month)) & ';' & Right(MinString([Quarter year]),2)

[tresB]

Check attached qvw

[#4]

You can use this ... But there should be always one selected ..

=Year&':'&Month(Month)&':'&Right([Quarter year],2)

[Anonymous]

Hi tresesco,

Thanks for your Time.

If i select only Month it should display :Jan

it would be getfield selections based

thanks,

[tresB]

Like this? PFA

Note, you can avoid the ';' symbols as well by checking null in a condition under if clause.