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

[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

[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

[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

[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

[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