Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

This seems like a simple question but there doesn't seem to be an answer online. I had a read through this: http://office.microsoft.com/en-au/excel-help/filter-data-in-a-pivottable-HA102840040.aspx but it doesn't seem to be much help.

Suppose I have a pivot table in which one of the count is a count of the number of times each value from another column appears in the data. Now I want to display only rows where the count is, say, larger than 1.

How do I do this?

share|improve this question
    
Your question is very unclear. Perhaps you could reword it and use some pictures so it's more clear? –  Raystafarian Feb 3 at 21:02
1  
Your link tells you how to do what you are looking for. Just select Value Filters and enter greater than 1. –  guitarthrower Feb 3 at 21:54
    
@guitarthrower you're right, I misread. –  quant Feb 4 at 3:50
    
added as an answer. If you mark as complete, it may help others with the same questions. Glad it worked for you. –  guitarthrower Feb 4 at 17:50

1 Answer 1

up vote 1 down vote accepted

Your link tells you how to do what you are looking for. Just select Value Filters and enter greater than 1.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.