Get a pivot table to ignore data

G

Guest

For example I have 2 columns of data. One column has names and the other a
score. A name can appear many times but I only want the pivot table to show
and count the instances where a certain score was achieved. So if someone
has passed they do not show on the pivot table but if they failed it will
give the count of fails and the score for each.

Robert 111 suggested a sumproduct function but I don't see how this would
help.
 
D

Debra Dalgleish

Add another column to the source data, and calculate if the score is a
pass or a fail. For example:

=IF(B2>=$E$1,"Pass","Fail")

Where scores are in column B, and cell E1 contains the minimum score
required to pass.

Add the new field to the pivot table's page area, and choose Pass from
its dropdown list.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get a pivot table to ignore some values 3
Pivot Table 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot table question 1
pivot table data 2
pivot table 1
Pivot Table 1
Pivot Table Data 1

Top