saved4use
asked on
Pivot table: issues with calculated field
I am getting the dreaded #VALUE! error in my pivot table when using the calculated field: =IFERROR(IF(OR(PATH=1,PATH =2),COMPL_ PKG/DEALS, ""),"")
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.
Thank you.
Path-EXa.xlsx
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.
Thank you.
Path-EXa.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.