Pivot tables and the "#N/A" error

  • Thread starter sunnyvale_playmaker
  • Start date
S

sunnyvale_playmaker

Pivot tables return "#N/A" when there are such errors in the relevant
underlying data. Is there a way to have the pivot table ignore those errors
and return the known data?
 
D

Dave Peterson

Maybe use a helper column and "hide" the error there.

=if(iserror(a2),0,a2)
(and drag down

and use this column in the pivottable.
 
Top