Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
No need to multiply with 100 if you check the show in percentage option.
Just use %=500/600 i.e ebit/revenue
Celambarasan
Hi,
There is no need of multiplying with 100, when you select percentage it automatically does this.
Hope this helps you.
Regards,
Jagan.