How to set the Pivot Table Layout

[snjpverma]

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:

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:

 

[sandy666]

I've no video, sorry
in PQ Editor find and open Advanced Editor and you'll see whole code, step by step
also all steps are on the right side in PQ Editor (if you click on each step you will see how it was done)
here are links where you can read and learn much more about PQ

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference

 

[snjpverma]

Thank you so much. I will surely look into the links.

 

[sandy666]

Sure,
Power Query is like an Art so almost each solution is different
Have a nice day