Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Line Break in Column Formula

943582Jun 21 2012 — edited Jun 22 2012
Is there an easy way to add a line break between two strings in a column formula and effectively use the column as a x-axis label (group by) in a bar chart? So, I have a dummy column in my analysis that serves as a chart label. It contains the string 'Top Perfomer' and I want the word Performer to show up underneath the word Top in the label.

I tried using the following: REPLACE('Top Perfomer', ' ', char(10)) based on something I read on a blog. This works to create the line break, but doesn't align the second word correctly under the first word in the label..Instead the word Performer shows up at the start of the new line, which is not what I want..

Is there an easier way to create a line break in this case? I am using 11.1.1.6
Comments
Locked Post
New comments cannot be posted to this locked post.