How do i get first value of a column in a straight table , below is sample data
Sample Data
Date Name Rating
4/4/12 John Expert
2/2/12 Sam Moderate
3/3/12 Nick Low
1/1/12 John Moderate
8/8/12 Sam Expert
1/1/12 Nick Expert
1/1/12 John Low
Expected Results : Name should be displayed based on Earliest Date , Rating should display based on Earliest Date and Highest Order ( Expert > Moderate > Low)
Final Output:
Date Name Rating
1/1/12 John Moderate
2/2/12 Sam Moderate
1/1/12 Nick Expert
