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 !

[#2]

You are using Sum(value), instead try max(value).

[MayilVahanan]

Hi

Try like this

=FirstSortedValue(value , - version)

Hope it helps

[help4qv123]

hi,

but i have an expression like count(value)...where max cant be applied

[help4qv123]

thank you. but here in my sample it is value which picks max value..but i have order column..i need the count of order for each key with max version.

my expression is count(ordr)

[#6]

I think MayilVahanan‌ had given correct solution.

[help4qv123]

yes its right, but it doesnt work in count...suppose my expression is count(ordr)...which need to pick the max version. then what wil be the expression

[#8]

something like this may be:

FirstSortedValue(aggr(count(value),version),-version)

[help4qv123]

no bro its not working

[jpenuliar]

max({<version = {'=Max(version)'}>}value)