Max of a column

[#1]

I have this pivot table.

The second columns have the sum of the sales in a day.

and the fourth column must have the max of the salesman.

I'm triing :

IF(Date>=vDateFrom and Date<=vDateTo,rangeMax(above( sum( IF(Date>=vDateFrom and Date<=vDateTo,Sales) ),0, rowno()) ))

and is doing the top of the nums above.. how can i do ???

Thanks

[#2]

Hi,

view attached file.

Alex

there's some error in file upload .

[#3]

there's some error in file upload .

sorry if you can upload ... i would thanks!!

[#4]

hi,

view attached file

Alex

[#5]

sorry i can´t open

i have 8.01 version

thanks for all.

[#6]

now i am triing :

max(aggr(sum(ALL <Place,Salesman,Date> IF(date>=vDateFrom and Date<=vDateTo,Sales) ), Place,Salesman,Date))

it is making the max of all the dimension but in the date of the salesman also must appear the max.

Thanks.