Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

So I have rows that look like this that are created via a pivot table:

uid did size count
101 m   100  5
101 m   75   8
101 m   20   3
101 w   80   7
101 w   100  3
102 m   100  2
102 m   50   1

And for each uid did pair I want to get the row with the largest count.

So from this table I want to get this smaller table:

101 m 75 8
101 w 80 7
102 m 100 2

Because 8,7 and 2 are the rows with the highest count.

Any suggestions on how to do this? There are several thousand rows.

share|improve this question
up vote 0 down vote accepted

I think a top 10 Value filter on the Size column will do what you want. You might need to adjust the "10", and make sure you set the 3rd column to "Sum".

enter image description here

share|improve this answer

Your Answer


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.