max sales

[prabhas277]

Hi experts,

salesperson, sales

A,10

b,20

c,30

a,15

b,25

c,35

now i want calculate the sum of max sales using set expression?

[Anonymous]

Max per sales person?  You don't need set here:

max(aggr(sum(sales),salesperson))

[maxgro]

sum of max sales by person?

=sum(aggr(max(sales),salesperson))

a and A are different

[cranium144]

This worked for me.  I used the following and it seems to work just fine.  (working with the max qty sold per part per day, not $ sold)

max(Aggr(sum([Invoice Qty]),[Invoice Date], PN))