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