Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can use Dual() :
=dual( sum(Sales) & ' (' & sum(SalesPD) & ')' , sum(Sales) )
=dual( 'Expression for Text you want show' , Expression with Chart Value )
Could you please post a screenshot of your requirement?
Hi,
Something like this, change from last day value in bracket.
Hi,
You can use Dual() :
=dual( sum(Sales) & ' (' & sum(SalesPD) & ')' , sum(Sales) )
=dual( 'Expression for Text you want show' , Expression with Chart Value )
Dear,
use the below expression
=dual( Sum([Sales]) & ' (' & ((Sum([SalesPD]))) & ')',(sum([SalesPD])) )
use dual function