Maximum value in pivot table

[swiftfahad]

how can I create a pivote table that show the sum(capacity) for the maximum refno.

Memo	RefNo	Capacity
ABC	45	2
ABC	46	3
ABC	32	14
XYZ	25	2
XYZ	29	17

required result is as follow plz suggest an expression i am using 

=max(aggr(sum(Capacity),RefNo)) but it show maximum value of capacity.

Memo	RefNo	Capacity
ABC	46	3
XYZ	29	17

app is also attatched

[tresesco · Accepted solution]

Like this?

FirstSortedValue(Aggr(Sum(Capacity),Memo,RefNo), -RefNo)

[swiftfahad]

Bingo.... Thanks champ