month year getselected field issue

[Anonymous]

hi gurus,

if i select Month Year it should display month in chart lable

output:Jan,Feb,Mar...........

multiple selection display

[marcus_sommer]

Try: = getfieldselections(Month, ', ')

- Marcus

[Anonymous]

but if i select month year it should display first 3 letters

ex:

source:     jan-12,feb-12

output:     jan,Feb

[marcus_sommer · Accepted solution]

Try: purgechar(getfieldselections(Month, ', '), '-0123456789')

- Marcus

[amit_saini]

Try this:

='Month'&chr(32)&if(GetSelectedCount(Month)>0,'- '&GetFieldSelections(Month))

Thanks,

AS