value as a % in pivot table

[#1]

hi friends,

how to format the value to show as a % in pivot table

forex:

revenue=600

ebit=500

%=500/600*100

i written expression like this to show %, by clicking number tab->fixed to>show in percentage

but its displaying like 1223.344%

Q.how can i achie % format manually in pivot table expression

[CELAMBARASAN]

Hi,

     No need to multiply with 100 if you check the show in percentage option.

     Just use %=500/600 i.e ebit/revenue

Celambarasan

[jagan]

Hi,

There is no need of multiplying with 100, when you select percentage it automatically does this.

Hope this helps you.

Regards,

Jagan.