Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I m using the expression to get the legend inside the stack bar.
=Dual([Dimension 1]&'-'&Sum(Value),Sum(Value))
but i want commas in number ti show it, when i use number tab and selecting the numeric format to get commas i m losing the dimension 1 on the stack bar
Add the num() function to your text representation:
=Dual([Dimension 1]&'-'& Num(Sum(Value),'#,##0.0','.',','),Sum(Value))
Adapt the format code as needed.
Add the num() function to your text representation:
=Dual([Dimension 1]&'-'& Num(Sum(Value),'#,##0.0','.',','),Sum(Value))
Adapt the format code as needed.