The best seller by product group.

[Ribeiro]

I need to know which seller sold more by product group. Like the image below.

Set analysis:

=FirstSortedValue(Apelido, -Aggr(Sum({$<Ano ={$(=Year(today()))},Mes={$(=Month(today()))},
[CodigoFilial]={'7'},[CodigoClasseCliente]={'1'},
[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={'0'} >}Preco_Final), CodigoGrupo))

What am I doing wrong...

Set analysis: Only a few sellers appear

[kishorj1982]

Hi,

In your scenario firstsortedvalues is not the best option.

You may use set analysis followed by aggr function for this.

Thanks

[Ribeiro]

Aggr (Only ({$ <Ano = {$ (= Year (hoje ()))}, Mes = {$ (= mês (hoje ()))},
[CodigoFilial] = { '7'}, [CodigoClasseCliente] = { '1'},
[Movimento_Tipo_Operacao] = { 'dev', 'VND', 'VPC', 'VEF', 'ECA', 'FPV', 'CVE'}, [Dt_Passou1] = { '0'} >} Apelido), Apelido)

did not work.. Any suggestion

[raman_rastogi]

Try This

=FirstSortedValue(Apelido, -Aggr(Sum({$<Ano ={$("=Year(today())")},Mes={$("=Month(today())")},
[CodigoFilial]={7},[CodigoClasseCliente]={1},
[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={0} >}Preco_Final), CodigoGrupo,Cod))

[Ribeiro]

I just brought a group with no rating

=FirstSortedValue(Apelido, -Aggr(Sum({$<Ano ={$("=Year(today())")},Mes={$("=Month(today())")},
[CodigoFilial]={7},[CodigoClasseCliente]={1},
[Movimento_Tipo_Operacao]={'DEV','VND','VPC','VEF','ACE','FPV','CVE'},[Dt_Passou1]={0} >}Preco_Final), CodigoGrupo,NomeGrupo))