I have sales figure in Dollars. By dragging them in treemap cells, I get the $ symbol by default. But within each cell, I have to prefix 'Sales:' and then display the figure. If i use the syntax 'Sales: ' str(SUM([Sales])), not only i loose the dollar symbol, I get the values in decimals. Please advice.
Use SUM([Sales]) and go to format and you can change the format of the number there.
You can go to 'Custom' option and put $00 then you will not get decimal values but you can get the $ symbol.