Hey y'all,
Question: Is it possible to add a calculated field (or some sort) that resembles a complex formula in a cell?
Example: I have a pivot table that lists a person's name, how many compliant items they had, how many non compliant items and the grand total (sum(compliant & non compliant)).
What I want to be able to add to the pivot table is a field that has a complex calculation.
What I have:
Count of C or NC Column Labels
Row Labels Compliant Non Compliant Grand Total
Joe Smith 9 24 33
What I would like to have:
Count of C or NC Column Labels
Row Labels Compliant Non Compliant Grand Total Compliance < 50%
Joe Smith 9 24 33 38%
Formula to get the 38%: =IFERROR(IF(Compliant/Non Compliant=0,"",IF(Compliant/Non Compliant<.5,Compliant/Non Compliant,"")),"")
I've attached a sample file to help.
Don
Bookmarks