Hi i got a issue with this can any one please help me

[chinnu123]

I have a 10000 rows of dats of employees which contain about their completion of courses.What I need is when i select a employee no i should get all the  courses  which he was completed if the employee completed the same course twice then i should get only latest end date of completion. For this iam sharing sample date once check and help me

[anbu1984]

Dimension: EmpNo

Expr: Max(Enddate)

[its_anandrjs]

Try this expression

Dimension:-  Enddate

Expression:- FirstSortedValue([emp no],Enddate)

And you get

          Enddate    Empno

12/12/2009

131

Regards

Anand

[mato32188]

Hello Chinnu K,

try attached file.

BR

M

[chinnu123]

Hi Martin i didnt get any attached file

[PradeepReddy]

In Straight table take the bellow measures.

Dimensions : EmpNo, ActivityName

Expression : Max(EndDate)

[jyothish8807]

Hi,

PFA

Regards

KC