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?

[Ribeiro]

on qvw above. It has a filter. When you take out the filter it will work. and you can see all the other customers and sellers.

[sunny_talwar · Accepted solution]

But CodigoCliente = 12710 only has Denise Garcia (Apelidox1) within the sample provided... how can you get to Rosane Antunes if it is not even available for 12710

[Ribeiro]

Data do not carry right, other sellers.

Thank you

[Ribeiro]

Congratulations it works 100%
Fix script ..

😃
Fix script ..