Show Real Value in 100% Stacked Bar

[Anonymous]

Hi Everyone,

I've problem to show value data in  100% stacked bar

For example in my expression:

My dimension in chart is CountryField

and 2 expressions:

Expression 1: SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)/(SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)+SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE))
Expression 2: SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE)/(SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)+SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE))

And I want to show value of Expression 1 is

SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)

and value of Expression 2 is

SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE2))"}>}VALUE)

how I can change data value on my bar chart?

Thanks for your answer

SUM({<DATE={"$(=DATE(TRX_DATE_COMPARE))"}>}VALUE)

[sunny_talwar · Accepted solution]

May be use Dual function like this

Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))

Dual(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE), Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE)/(Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE))"}>} VALUE) + Sum({<DATE = {"$(=DATE(TRX_DATE_COMPARE2))"}>} VALUE)))

And select Expression Default on the number's tab for formatting and see if that works for you.

[Anonymous]

Thanks Sunny, I forget to set expression default number.