Hi,

I have a case where i need max at a particular level -

Say for example, we have a dataset of -

A 1

A 2

A 3

B 1

B 5

C 2

C 7

Desired output - (preferably a calculated field) 3rd column. Here i need max on 1st column level. I know it works in 9.0 using 'fixed' but i need a solution which can stand on 8.2 version.

A 1 3

A 2 3

A 3 3

B 1 5

B 5 5

C 2 7

C 7 7

Here 3 is max for the values in set A, 5 is the max for the values in set B and so on.

• Thanks,