Hi!

I am doing some reports using PivotTable format. The value (measure) in the table, i changed it to be viewed as "percentage of row" of the original value (by right-click at the pivottable > Field Settings... > Option>> > select Show data as: % of row > OK > OK). The report will be displayed as percentage value with the '%' sign.

Is there any method to get rid of the '%' sign, which means the report still be displayed as percentage value, but without the '%' sign?

I try to not include the '%' sign, then the percentage value will be shown as value after divided by 100 (for example, 90.6% -> 0.906). I really need help on this URGENTLY, because the requirement for these reports is not to show the '%' sign for percentage value in the reports.

Thank you very much.

Regards,
xhuey