saved4use
asked on
Pivot table percentages
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.
Path-EX.xlsx
How can I solve this? *See attachment
Also how do I eliminate the #DIV/0! error?
Thanks for your tremendous assistance.
Path-EX.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@tomfarrar It seems the calculated field produces the perfect percentages when it's only 7 rows of data and NOT when it's 52,500 rows of data (as you can see the multitude of 0.00% throughout the attached pivot table). How can the calculated field be tweaked to reflect correct percentages with a larger dataset?
Thank you for your help (we are close).
Path-EXa.xlsx
Thank you for your help (we are close).
Path-EXa.xlsx
Look at the attached and then we can discuss. See notes off to the right of Pivot Table.
Path-EX2.xlsx
Path-EX2.xlsx
Sorry wrong file attached. See this one......
Path-EX3.xlsx
Path-EX3.xlsx
Pivot Table Menu: Options>Layout & Format > Format > For Error Values Show "0"
Or go to your calculated field PKG_% and surround the formula with IfError(Calculated Field), "')