I need to know which seller sold the most for customers.($)

[Ribeiro]

need to correct the set analysis below. For a seller who sold more, not the last seller.

I would like to know which was the best seller of each customer.

=FirstSortedValue(Apelidox1, -Aggr(Sum({$<[Movimento_Tipo_Operacao]={'VND'},[Apelidox1]-={'Brindes'},[CodigoClasseCliente]={'1'},[Dt_Passou1]={'0'} >}Preco_Final), CodigoCliente))

But in the set analysis she is bringing the seller's last sold seller.

In the images below see the example:

The saleswoman Denise Garcia was the last saleswoman by date. But who sold the most went to Rosane Antunes?

[sunny_talwar]

May be try this

=FirstSortedValue(Apelidox1, -Aggr(Sum({$<[Movimento_Tipo_Operacao] = {'VND'}, [Apelidox1] -= {'Brindes'}, [CodigoClasseCliente] = {'1'},[Dt_Passou1] = {'0'}>} Preco_Final), CodigoCliente, Apelidox1))

[Ribeiro]

Rosane Antunes correct:

Who else sold in Valor. Denise Garcia is the last seller and was the one who sold the least.🙄

[sunny_talwar]

Did you try changing to the new expression?

[Ribeiro]

follow qvw above

[sunny_talwar]

In the above qvw, I am only seeing Denise Garcia for 12710... Is this data missing the other option?

[Ribeiro]

Yes

[Ribeiro]

Is filtering by client code on qvw

[sunny_talwar]

Then how can I determine if the expression I gave it working or not...

[Ribeiro]

Rosane Antunes correct