Percentage on chart expression with two dimensions

[sifatnabil]

Hi all,

Normally with 1 dimension on a bar chart, we can get a "% of total" value at the bottom of each bar by ticking "invisible" and "text on axis" like below:

However, the % value does not work when using 2 dimensions. Is there any way to preserve the % values while having 2 dimensions?

[PrashantSangle]

can you provide sample data with required output???

Regards,

[sifatnabil]

Hi, please see attached. I'm trying to get the % values on the second chart in my app, just like the first chart. The second chart has 2 dimensions.

[stigchel]

In display options remove the bar option, see attached

[sifatnabil]

Thanks - however, when there are 2 parts on a bar chart, it's showing 2 %s, e.g. 20% and 7% in your attachment for Dimension "C". Is there a way for it to have a singular value = 27%?

[stigchel · Accepted solution]

Change the expression to calculate the total and only display for the first row

if(Rowno()=1,

sum(TOTAL <Sector> [Order size])

/

sum(TOTAL [Order size])

,'')

[sifatnabil]

That's awesome, thanks. I noticed that the %s aren't on the same horizontal alignment, is there a way to align them?

[stigchel]

I don't think so...