Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Maybe like attached (note the format changed to expression default, too, on number tab)
Maybe like attached (note the format changed to expression default, too, on number tab)
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.
Try this with add another expression and set it as Text as Pop UP
Try with :
dual(sum(Sales)&Chr(10)&num(sum(Sales)/sum(TOTAL Sales),'# ##0,0%') ,sum(Sales))
Hi aretha,
I assume, this is first issue. Can you re calculate with num() for first argument