Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Can you attach sample file and let us explain with example and expected output.
Regards,
jagan.
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)
Hi Are,
if I understand you meaning, something like the attached?
hope that helps
Joe
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
Ah I missed the spaced fieldnames, should work for you now
Joe
Hi joe,
if i select year,Region,Health Authority-> showing only Health Authority
missing year and Region
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
Hi Joe,
Thanks for Valuable time
You are Genius
Thanks,
Are
No worries, glad to be of help