How to show the string by min value in pivot table?

[Anonymous]

LOAD * INLINE [

Period, Employee, Course, Grade

2010Q1, Emp1, Cor1, B3

2010Q1, Emp1, Cor2, A3

2010Q1, Emp2, Cor1, A2

2010Q1, Emp2, Cor2, B1

2010Q2, Emp1, Cor1, A2

2010Q2, Emp1, Cor2, B2

2010Q2, Emp2, Cor1, A3

2010Q2, Emp2, Cor2, A2

…  

2010Q4, Emp1, Cor1, A1

2010Q4, Emp1, Cor2, B1

2010Q4, Emp2, Cor1, A1

2010Q4, Emp2, Cor2, A3

];

LOAD * INLINE [

GradeID,Grade

1, A1

2, A2

3, A3

4, B1

5, B2

6, B3

7, C1

8, C2

9, C3

];

I want to get every Grade by min GradeID as below pivot table.

	2010Q1	2010Q2	2010Q3	2010Q4
Emp1	A3	A2	…	A1
Emp2	A2	A3	…	A3

[CELAMBARASAN]

Hi,

Use FirstSortedValue for this case

=FirstSortedValue(Grade,GradeID)

Hope It helps

Celambarasan

[jvitantonio · Accepted solution]

Either your example is not accurate or I'm wrong, but the min for Emp2 for 2010Q4 is A1 and not A3.

Check the app. I hope it helps.

[Kushal_Chawda]

Hi,

see the attched application

Regards,

kush

[Anonymous]

Thank you kush. That is just exactly what I need.