Aggr on rank

[renjithpl]

Hi All,

I have an input table like below

ID	Category	Coins	Rank
1	A	Silver	2
1	B	Gold	1
1	B	Silver	2
1	B	Bronze	3

and I want the output table like below

ID	Category	Coins	Rank
1	A	Silver	2
1	B	Gold	1

Rank is the expression field like aggr(max(Rank), ID, Category)

[sunny_talwar]

May try this:

Dimensions:

1) ID

2) Category

Expression

1) Min(Rank)

2) FirstSortedValue(Coins, Rank)

[Chanty4u · Accepted solution]

use FirstStoredValue(Distinct Category,-Rank)

[swuehl]

What do you mean with

"Rank is the expression field like aggr(max(Rank), ID, Category)"

Rank column is a calculated column, but self referencing?

[renjithpl]

When I used distinct its showing red line under the expression.

I have used without distinct its giving me the right output.

Thanks

[sunny_talwar]

Red line doesn't mean anything in this case. It just means that expression editor doesn't understand the syntax, but the expression should still work if you click okay.