Set analysis max value

[help4qv123]

HI,

i have 3 columns..

By default i need a bar chart ,if u  select a key there is some max version for that key..i need the value of that version for all keys.

i have attached a sample for u..plz refer to that !

[jpenuliar]

front lookis like below:

[maxgro]

try with this exp

subfield(concat(value, '@', -version), '@',1)

[ToniKautto]

The absolute best way is to find a way to flag the max value during load. Then use the flag in a set expression to get the expected set for the aggregation.