Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a bar chart like this:
My expression is below:
=Dual(Num(Sum(ContractDollars) / Sum(TOTAL <CstFiscalYear> ContractDollars), '#.#%'), Sum(ContractDollars) / 1000000)
Now I want to show the Sales Value as well in Bar just below the Percentage value.
Could you please help me on this.
Thanks,
Sarif
Example in the attachment
maybe with 2 expression
Sum(ContractDollars)
Num(Sum(ContractDollars) / Sum (TOTAL <CstFiscalYear> ContractDollars), '#,##0.0%') &
chr(10) &
Num(Sum (ContractDollars), '#,##0')
for the second expression uncheck bar
and check value on data point
Not working sir..
Please help.
Thanks,
Sarif
Example in the attachment
Nice one, thank you!