Pivot Table % calculation

J

jerry

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
 
D

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
 
J

jerry

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