I have source data that shows 3 paths (Path 1, 2, 3), yet when it displays percentages, I only want the pivot table to reflect percentages for only Path 1 and 2. I can hide path 3, but the percentages still count the path 3 numbers.
How can I solve this? *See attachment
Also how do I eliminate the #DIV/0! error?
Thanks for your tremendous assistance.