Link to Table...
http://i.stack.imgur.com/hUVfc.png
I have a table with multiple repeated values associated with a certain group. I'm trying to scope out the max for each group, then sum it.
Answer needs to be 50 + 25 + 10 + 70
I've tried various SUMX and can't seem to get the filter correct.
Thanks,