concatenation of two expressions in a chart

[arethaking]

Hi,

My chart is showing Sales by region. I want to show Sales & % of Sales for each region as data values.

I am using Sales & % of Sales expression in dual function. But it is not working.

dual(sum(Sales)&'-'&sum(Sales)/sum(TOTAL Sales),sum(Sales))

I want to show 'Data Values' for 4 Regions?

Please help me.

Region	% and Sales
GERMANY	5.45% - 392,487
JAPAN	18.63% - 1,341,699
UK	17.67% - 1,272,507
USA	58.25% - 4,195,256

[swuehl · Accepted solution]

Maybe like attached (note the format changed to expression default, too, on number tab)

[rubenmarin]

Hi Aretha, uncheck the 'relative' check box to make it work this way.

Another option is add 2 expression: one in % and other with the value. You can show one value in chart and the ithe on the legend.

[its_anandrjs]

Try this with add another expression and set it as Text as Pop UP

[sergio0592]

Try with :

dual(sum(Sales)&Chr(10)&num(sum(Sales)/sum(TOTAL Sales),'# ##0,0%') ,sum(Sales)) 

[Anil_Babu_Samineni]

Hi aretha,

I assume, this is first issue. Can you re calculate with num() for first argument