Pivotal Table base on cell value

Hi everyone,


I have some difficulty in solving a pivotal table with a cell reference value.

I have this table:

Name	Ratio	SELECTED
Name1	5.88	YES
Name2	5.88	NO
Name3	5.88	YES

I want this to happen in pivotal table:

Name	Ratio
Name1	5.88
Name3	5.88

Attached is my sample sheet.

Thanks.

I do not understand a problem, see if that's it?

Originally Posted by stasinek

I do not understand a problem, see if that's it?

you only uncheck the "NO" value...

i want an automatic filter in pivot table..

Is it OK now ?