Firs stored value group by

[krmvacar]

Hi , 

I have the following data. What I want to do here is to get the highest customer number from the ones that contain the customer ID in (1,2,3) and collect their price.

my expression;

sum(aggr(FirstSortedValue([TOTAL_PRICE],-Aggr(sum({<[OFFER_ID]={'01','02','03'}>}[OLPSALHEAD.DOCNUM]),[TOTAL_PRICE],))
,[Customer_Name]))

its not working 😞

Help please

[agigliotti]

Hi @krmvacar ,

It's not clear to me, what is your actual result and the expected one?

[krmvacar]

Hi @agigliotti  ,

get the price of the person with the highest offer  number

[AshutoshBhumkar]

Hi, Is the expected output 149000 ?

As Customer JOHN Contains Offer id 1,2,3 and max offer number 1347.

[krmvacar]

Hi @AshutoshBhumkar ,

Yes for JOHN 149000 and max offer number 1347 and for ABC max offer number 1455.

thank you so much