I have two expressions and one dimension in a line chart. I would like to format the expression as Money format ('$#,##0'). I used this in my two expressions like Money(Sum(CM),'$#,##0') and Money(Sum(CM1),'$#,##0') but somehow it is not showing in the Y axis. I get a plain number like 5,000,000 in the Yaxis. Can someone please help on this? what is the issue?
