Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
FirstSortedValue(Aggr(Sum(Capacity),Memo,RefNo), -RefNo)
Bingo.... Thanks champ