Hi,
I'm wondering if there is a way to combine the IF and IFERROR function with the GETPIVOTDATA function based on the following rule I would like to use:
Search within the pivot table based on criteria (GETIVOTDATA) and IF the value within my pivot table is 0% or IFERROR then return #N/A, otherwise return the value from the pivot table.
I have tried something along the lines of:
IF(IFERROR(GETPIVOTDATA('getpivotdata formula'),'#N/A',GETPIVOTDATA('getpivotdata formula').
Any help would be appreciated as I'm fairly new to excel.
Thanks