RoundOff of Sum in Pivot chart

[#1]

Hi,

can anybody suggest me how to roundoff the sum in Pivot chart, the summing is done by checking the show partial sum under Presentation Tab.

Thanks

Arun

[#2]

Hi Arun,

Go to Chart Properties-Number in pivot chart.

Instead of default, select "Fixed to" and then select no. of decimals you want.

If you make it zero, it will automatically get rounded off.

Happy Thoughts

[brenner_martina]

Hi, Arun,

if you want the values be rounded use function round or ceil or floor

[#4]

Thanks