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