am trying to find how to get the max of column a for each value in column b

[scott bailey 2]

i have tried several ways but is all basd on column details not column b details

Please help

Am very new to spotfire so all help would be appreciated, would also like to learn so any helpful tips would go a long way

thank you

[venkataramanan k]

can you upload any sample workout. col A, col B and result col.

[Fabian Duerr]

Welcome to Spotfire ;)

Max([ColA]) OVER [ColB] should do the job for you

PS: And just likekrithivenkatsaid it will help us to help you if you upload a sample file :)