Bar chart with values in brackets

[#1]

Hi,

I have a requirement where I need to show sales Bar and value of change in sales from previous day in brackets at the end of the bar.

PFA the demo app.

Regards

Navdeep

[#2]

Could you please post a screenshot of your requirement?

[#3]

Hi,

Something like this, change from last day value in bracket.

[jonasheisterkam · Accepted solution]

Hi,

You can use Dual() :

=dual( sum(Sales) & '  (' & sum(SalesPD) & ')' , sum(Sales) )

=dual(  'Expression for Text you want show'  ,   Expression with Chart Value  )

[mdmukramali]

Dear,

use the below expression

=dual( Sum([Sales]) & '   (' & ((Sum([SalesPD]))) & ')',(sum([SalesPD])) )

[deepakqlikview_123]

use dual function