Issues export currency and percentage formats in excel

[#1]

Hello,

I have a pivot table with various numeric values, a few of which are formatted in currency and percentages. When I export the chart to excel these formats disappear. How can I maintain them? Here is the current syntax I"m using:

num(sum([Field 1]), '$##.##'),

num(sum([Field 3]) / sum([Field 4]), '#,##0.00%'),

[sundarakumar]

try to set the number formatiing in number tab. This will be carried over to the export i guess.

or try to round it while loading, this would improve the performance also.

-Sundar