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.

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
add comment

1 Answer 1

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
add comment

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.