Selected Dimensions concatenate and separate with chr(10) in Barchart

[Anonymous]

Hi Gurus

i have 3 Dimensions

Year

Region

Site

user can select 3 Dimensions  from the list of used Dimensions List box

after selecting 3 Dimensions ,3 Dimensions should Concatenate and add as a single Calculated Dimension separated with Chr(10) or chr(13).

example:Year&chr(10)&Region&chr(10)&Site

[jagan]

Hi,

Can you attach sample file and let us explain with example and expected output.

Regards,

jagan.

[Anonymous]

based on left side selected dimensions,it should add as a single calculated Dimension  in Bar chart

Example:Year&chr(13)Region&CHR(13)&Site

It Should happen based on selection Dimensions by user not Manual

Sample output:

Concat(Selected dimension1&chr(13)&selected dimension2&chr(13)&selected dimension3)

[#4]

Hi Are,

if I understand you meaning, something like the attached?

hope that helps

Joe

[Anonymous]

Hi Thanks for your time

logic matching with my requirement

But if i click Year,Region,Health Authority -> Showing Error in Calculated Dimension

Thanks In Advance

[#6]

Ah I missed the spaced fieldnames, should work for you now

Joe

[Anonymous]

Hi joe,

if i select year,Region,Health Authority-> showing only Health Authority

missing year and Region

[#8 · Accepted solution]

early morning, missed a space!

Also changed from chr 10 to 13, as with 10 it doesn't format very well

hope that helps

Joe

[Anonymous]

Hi Joe,

Thanks for Valuable time

You are Genius

Thanks,

Are

[#10]

No worries, glad to be of help