Hi,
I was wondering if anyone know's of a way that you can avoid getting a #REF! error when there is no data in a pivot.
For example I have a table that references a pivot. Some days when I refresh the data-set there will be matching figures against all of the dates.
Is there any way that I can show nothing if there is no data.
I tried this but there are too many arguments.
=ISERROR(GETPIVOTDATA("# of Bookings",'V OUT PY'!$A$5,"Entry Date",$C70,"Bucket 60 Min",$BL$2),"")
Thanks,
Paul
Bookmarks