two table-chart with different total mode. How can i format total in table-chart two on right side with correct format.
didn't get you, what is the desired output?
I undertand you want 1.250 instead 1,250
In expression use:
= 'Total ' & Num(Sum(Value),' #.##0')
In script you must change:
Thanks, Total 1.250 is on left side in column and I need Total 1.250 on right side.
apply the above technique.
from presentaion tab--select ur field--set alignment as Right
See attached, changed the label expression and in the presentation tab set the orientation to right
Change the Label From
= 'Total ' & Num(Sum(Value),' #,##0.', '.', ',')
= 'Total ' & Num(Sum(Value),'#.##0', ',', '.')
Just swapping the decimal and thousand seperators round
hey,whr is the orentaion in presentaion tab? very funny...
Values should be on right side, strings without values on left side!
friend,that's alignment not orientation..that's ' wht I said in the above post's.
Retrieving data ...