Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

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
0
saved4use
Asked:
saved4use
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
I created a calculated item called "Path12" which combines totals for just those two path values.  Then I added a calculated field called "CompPct" with this formula:
=IF(DEALS=0,0,COMPL_PKG/DEALS)

I've modified your PivotTable to show the raw counts for DEALS, COMPL_PKG and the calculated percentages based on the two.  If you hide the three individual path values of 1,2,3 from the columns (using the filter next to "Column Labels"), you'll see just the counts and percentages for Path 1 and 2 totals only.

Regards,
-Glenn
EE-Path-EXa.xlsx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now