How to show specific character in Chart legend?

[vaghamshi]

Hi Guys, Please help me, How to show specific character in chart legend-

I have two groped dimension 1) Region & 2) SubRegion 

Region Name -

Asia

North America

I want to show only "A" in this case

& 

Sub region name-

ACN / China

AAN / Ocenia 

I want to only show "ACN"

Please help me in this case.

Below case, I only Want "A" & "N" Respectively:-

Below case, I only Want "ACN" & "AAN" Respectively:-

[Brett_Bleess]

Very helpful to attach QVW file in these situations, so people can see the data model and full chart properties etc. to try different things and have a better idea of what may be possible.  If you have sensitive information in the app, you can use the Settings\Document Properties\Scrambling tab to scramble those fields before attaching.  I suspect that will help get some responses.

Regards,
Brett