Straight Table chart..calculated Dimension

[pra_kale]

Hi,

I have created one straight table with 4 dimensions. My requirement is that I want one another additional dimension which is concatenate of this 4 dimensions. Also I want to give the name to that dimension.

I have tried it by '$' between two columns, but it is not working as I can not give a name to the newly added dimension also I want space between two dimensions names.

Can any one help me in this.

Thanks in Advance.

[ramoncova06]

have you tried using '&' ?

the syntax would be like

dimension1&dimension2&dimension3&dimension4

[pra_kale]

Thanks for your reply.

Yes, I have tried it same way, but how to give name to the added dimension as I am getting that formula only at that place as a dimension name...also I want to give space between them. Whether this Two things are possible?

[#4]

Type the name you want in the label section. Also if you want a space then it should be, name1& ' '&name2&'  '&name3&' '&name4. Thanks

[ramoncova06]

as Srukmana mentioned you need to add a label for any calculated dimension otherwise the label will show the expression being used