How to filter a subtotal in a pivot table

[TODDLL]

I have a pivot table with a column called "Name". I have another column called "Qualified". The Name column can have the same name listed in mutiple rows. Each row under the "Qualified" column will have either a 1 or a 0.
I would like to sum the Qualified column by the Name column. If the sum of all rows for a specific name is "0", I want to only display those names.
I set up the Qualified column in Values, not Row Labels and set it to SUM. Just can't figure out how to filter that column by the sub total

 

[ER_Neha]

Hello.
If I am getting your query right then this can be easily done by applying the value filter in the pivot table and applying equal to zero.
I am attaching the image of the process, for making steps clear to you, also the excel output. I hope this help you.

Best Regards.

Book2
	A	B	C	D	E	F	G
1	names	qualified				Row Labels	Sum of qualified
2	ankit	0				ankit	0
3	punit	0				Grand Total	0
4	ankit	0
5	punit	1
6	ankit	0
7	neha	1
8	riya	1
9	rahul	1
10	neha	0
11	riya	0
12	rahul	1
13	ankit	0
14	punit	0
15	neha	1
Sheet1

 

[TODDLL]

Thank you for the quick response. When I click on the dropdown list in the names column, I do not have the "Value Filters" option, only text filter and color filter option. My pivot table has multiple columns, not just the name and qualified columns. Does that have something to do with it?

 

[ER_Neha]

Thank you for the quick response. When I click on the dropdown list in the names column, I do not have the "Value Filters" option, only text filter and color filter option. My pivot table has multiple columns, not just the name and qualified columns. Does that have something to do with it?

Hello, Can you please tell the Excel version you are using ?

 

[TODDLL]

Excel 2010. I decided to start from scratch again using my data, and now, I do have the value filter option available in the drop down list, so something must be messed up in my original file. You have been extremely helpful, and this has accomplished what I was looking for. Thank you so much. I was thinking it was much more complicated than it turned out to be.

 

[ER_Neha]

Excel 2010. I decided to start from scratch again using my data, and now, I do have the value filter option available in the drop down list, so something must be messed up in my original file. You have been extremely helpful, and this has accomplished what I was looking for. Thank you so much. I was thinking it was much more complicated than it turned out to be.

Happy to help. Keep going with your work.