Want the first bar to show the Count and %, but using the formula, only one character comes up

[Sxbbb]

Want the first bar to show the Count and %

Code used OK

Code used NG

[Sxbbb]

want to display every bar

[MayilVahanan]

HI

Did u check the "Value on Data Points" on the first bar ?

[Sxbbb]

Result :

[Sxbbb]

Want the first bar to show the Count and %

[MayilVahanan]

Hi

Try with Dual function like below

Dual(100 &'('&10 &'%)',100)

 Dual( ur display expression , ur bar height expression)

[Sxbbb]

At first I did this. But I want concatenated values ​​like 49(91%) and 5(9%) to be in 1 bar chart.

Code Count OK : (Sum(CountSpindle)-Sum(CountReject))

Code Count NG : Sum(CountReject)

Code %OK : (Sum(CountSpindle)-Sum(CountReject))/Sum(CountSpindle)

Code %NG : Sum(CountReject)/Sum(CountSpindle)

[MayilVahanan · Accepted solution]

Hi

Try like below

Code Count NG:

Dual(Sum(CountReject)&'('& Num ( Sum(CountReject)/Sum(CountSpindle) , '#,##0%') &')',

Sum(CountReject))

Code Count OK : 

Dual( (Sum(CountSpindle)-Sum(CountReject))&'('& Num ( (Sum(CountSpindle)-Sum(CountReject))/Sum(CountSpindle) , '#,##0%') &')',

 (Sum(CountSpindle)-Sum(CountReject)))

[Sxbbb]

I got it, thank you very much