Aggr() dimension

[ciampaciampa]

Hi there,

here my problem...

From the Raw Data Table I want to catch the row in red border (for each Symbol/Sequence is the value of LastSale for the higher value of Count)

If I build a new aggregate table using an Aggr() as dimension,  the Sum(LastSale) seems don't take into account the Aggr() dimension. Instead the value is exactly the sum of all rows.

What's wrong?

Thanks a lot in advance

[sunny_talwar · Accepted solution]

May be try this

FirstSortedValue(Aggr(Sum(LastSale), Symbol, Rilevamento), -Aggr(Rilevamento, Symbol, Rilevamento))

[ciampaciampa]

It works!

Thanks Sunny.