I'm using a pivot table to analyse some data but am a bit stuck at the
moment. I'd like to have the pivot table find, for a group, the maximum of a
column (Depth), return that value and also return the value from the same row
but from a different column (Location).

Group Depth Location
------------------------------
1 0.1 a
1 0.2 b
1 0.1 c
2 0.1 d
2 0.3 e
3 0.5 f
3 0.2 g
3 0.4 h

Results should be:

Group Max Depth Location
----------------------------------------
1 0.2 b
2 0.3 e
3 0.5 f

Thanks,
Sean