Aggr

[#1]

Hi all.

I have this table:

ID, Product, Name, Amount

001, B, AA, 150

001, B, BB, 130

002, B, CC, 170

002, B, DD, 190

and i want obtain this output:

ID, Product, Name, max(Amount)

001, B, AA, 150

002, B, CC, 170

I try to use in a table

dimension: ID, Product, Name

and expression: only(aggr(max(Amount), ID, Product, Name)

but not works.

Someone can help me?

Regards,

Marco

[whiteline]

Hi.

If you just want first lines you could use MinString(Amount)

[#3]

no works

[MayilVahanan · Accepted solution]

HI

May be try like this

=Aggr(Max(Amount),Id)

Hope it helps

[#5]

Thanks, It works!

[whiteline]

In this case you shoud have:

ID, Product, Name, max(Amount)

001, B, AA, 150

002, B, CC, 170 190

[#7]

its working fine