Display $ symbol to data in Pivot table

[jagannalla]

Hi,

- I had a data in pivot table with two dimensions and four expressions.

- The dimensions are Ctype and CName and Expressions are sales,cgs,margin,margin%.

- All expressions had numeric data. Now, i want to display $ symbol infront of each data in the expressions.

For eg: $ 1000000

$200000

How can i do this? Can anyone help me.

[#2]

in table properties open number tab, than select your expression and chose your format setting, in your case it's Money

[jagannalla]

Thank you so much....Actually i tried same settings but not with money.