who can help to solve this problem?

shellchan

firtly,my report like this:
_______________________
year jan feb ...
1992 233 32 ...
1993 76 198 ...
... ... ... ...
2008 146 45 ...
_______________________
avg: 102.1 98.5 ...
max: 233 198 ...
max-year: 1992 1993 ...
min: 76 32 ...
min-year: 1993 1992 ...
________________________

avg ,max ,min : i can use function avg(), max(),min()
but, i can not implement max-year or min-year ,because max-year is dynamic value with month(jan,feb,...) who can help me ,how to solve it.
give me script or setting method.

thank you everyone !

thank you everyone.

FRNL

shellchan wrote: »

firtly,my report like this:
_______________________
year jan feb ...
1992 233 32 ...
1993 76 198 ...
... ... ... ...
2008 146 45 ...
_______________________
avg: 102.1 98.5 ...
max: 233 198 ...
max-year: 1992 1993 ...
min: 76 32 ...
min-year: 1993 1992 ...
________________________

avg ,max ,min : i can use function avg(), max(),min()
but, i can not implement max-year or min-year ,because max-year is dynamic value with month(jan,feb,...) who can help me ,how to solve it.
give me script or setting method.

thank you everyone !

thank you everyone.

I'm not sure if I understand the question
Max(Yearof()) if you have month and date with it?

Best regards,
Teo