Below is a sample file for which I am unable to figure out pivot table layout.
I tried but due to my lack of Pivot Table experience I am unable to get the desired output. I have attached an excel file reflecting my desired output and the output that I am currently getting. Please assist in getting desired output for this sample data.
I tried but due to my lack of Pivot Table experience I am unable to get the desired output. I have attached an excel file reflecting my desired output and the output that I am currently getting. Please assist in getting desired output for this sample 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 |