Top function not functioning as intended

[JohnSpot]

Hello all,

Thanks in advance for the time you will dedicate to my topic !

I am trying to retrieve the first value of a column (which looks straighforward 🙂 ) and elected to use the Top function.

Super simple. But when I display Top(saEntite), it does not work but displays invalid function.

Is there something obvious I am missing ?

Would anyone have any advice ?

Thanks a lot !

Cheers,

Guillaum

[rubenmarin · Accepted solution]

Hi, I'm not suere why it doen't works, if you have a field Dim1 with values A,B,C and you use Top(Dim1) it will show 'A' on all rows.

Note that this is an expression, maybe you are trying to use it as dimension instead of as expression?

As a Dimension it could be something like :=Aggr(If(Dim1=Top(Dim1), Dim1), Dim1)

[JohnSpot]

Holly molly,

You make life look easy.

It worked. Thanks a lot !