I am getting the dreaded #VALUE! error in my pivot table when using the calculated field: =IFERROR(IF(OR(PATH=1,PATH
Can you help identify what the error is and perhaps provide a solution. *Pivot table is attached below.
FYI, I only want the pivot table to display percentages for only Path 1 and 2 and NOT include counts of Path 3 in the percentages.