As shown in below Table. "F" has sold 2 items out of which one is defective. i.e. 50% of what he has sold is defective. How do i represent this in Pivot Table?
I am unable to figure out the Layout.
Raw Data:
I tried as shown below, but I get it as 100% for all the Sales executives. Please suggest as I am definitely missing something.
My Pivot:
I am unable to figure out the Layout.
Raw Data:
Sales Executive | Products Sold | Defective |
F | XYZ | NO |
D | XYZ | NO |
F | XYZ | YES |
C | XYZ | YES |
A | XYZ | YES |
C | XYZ | NO |
B | XYZ | NO |
B | XYZ | NO |
D | XYZ | NO |
A | XYZ | YES |
G | XYZ | YES |
G | XYZ | NO |
G | XYZ | NO |
E | XYZ | NO |
I tried as shown below, but I get it as 100% for all the Sales executives. Please suggest as I am definitely missing something.
My Pivot: