Pivot Table % calculation

[Guest]

I am getting a div/o error, when i insert a calculation into a pivot table.
How can i leave blank instead of getting the Div/0 error

thanks
jerry

 

[Debra Dalgleish]

You can hide the errors:

Right-click on a cell in the pivot table
Choose Table Options
Add a check mark to 'For error values, show'
Leave the text box empty
Click OK

 

[Guest]

thanks debra. i actually was able to figure this one out . But thanks for
responding!