one way might be:

=IF(ISERROR(GETPIVOTDATA(...)),0,GETPIVOTDATA(...) )




On 27 Lut, 14:59, PerryK wrote:
I have a pivot table that summarize sales by manager.

I am using the "=GETPIVOTDATA" function to capture the data into a table.

The table lists the managers name in column A and the summary data from the
pivot table in column B

One of the managers has not had any sales so far this year, so they do not
show up in the pivot table. This causes the #REF! error in the table.
I would like for it to show "0" or just be blank instead of it showing #REF!.

Is there an easy way to hide this error?

Thanks

--
Perry K