put into a text object the best customer

[#1]

Hi all,

I post here my model:

I wish to extract the CustomerCode corresponding to max(sum({$<Type={'P'}>} [Sales Amount]) )

Can anyone help me?

Thanks a lot!

[#2 · Accepted solution]

Hi Roberta,

Here you are:

=aggr(if(max(total aggr(sum({$<Type={'P'}>} [Sales Amount]),Customer))=sum({$<Type={'P'}>} [Sales Amount]),Customer),Customer)

Regards

Karol

[#3]

Thanks Karol!

It works well!

Roberta