Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivot using calc

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot - using Calc field

Pivot - using Calc field

ResolvedVersion 2010

Lien has attended:
Access Introduction course
Excel Advanced course
Access Intermediate course
Excel VBA Introduction course

Pivot - using Calc field

I enter a percentage calc column using Calculated field. When there are fields with no data this shows as #DIV/0! which clutters the pivot. How can I get it to show no value instead? Thanks

RE: Pivot - using Calc field

Hello Lien,

Thank you for your post. To get your pivot table to show something other than error messages, click on the Options tab, then click Options on the left of your ribbon. In the box that opens, tick the box next to "For error values show".
In the field to the right of that, type in what you would like the pivot table to show instead of an error message.

I hope this is helpful.

Kind regards

Marius Barnard
Excel Trainer


Wed 7 Dec 2016: Automatically marked as resolved.

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.