I am getting the results within a table as "#REF!" as the item its looking for is not presewnt in the pivot table, so i was wondering how can I change this to if not found show as 0
=GETPIVOTDATA("Job Type",$P$28,"Booking Status","Booked")
=GETPIVOTDATA("Job Type",$P$28,"Booking Status","Booked")
Last edited: