How to execute two dimension in a single expression

[#1]

Hai,

Any one pls help me with this fix..?

I have an example here ..pfa

In that I am taking top 10 customers based on order sale amount

I have taken customers as dimension and sum(ordersaleamount) as my dimension.

but I want customers respective country also in a same bar chart near to a customer or near to a value in bracket().

Thanks in advance..

[#2]

I am asking for an bar chart

[#3 · Accepted solution]

Sathiyanc

I found a way to do this on a bar chart, using the above suggestions of a calculated dimension with the chr(13) or chr(10 added in the middle, you must then also change the direction of the labels. It doesn't work on a bar chart when the labels are horizontal, but if you change the axis labels to diagonal or vertical then it will work, see below image.

You can do this at the bottom of the Axes tab as shown below:

[nizamsha]

=Date( Country,'YYYY') & chr(10) & chr(13)& Customer