Pivot tables and the "#N/A" error
 

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?
--
Regards,

Ryan

Pivot tables and the "#N/A" error
 

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.

sunnyvale_playmaker wrote:

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?
--
Regards,

Ryan

--

Dave Peterson