Sorting Data - First sorted value - Pulling corresponding Text Field

[#1]

Hi

I am struggling putting together a summary table for the Base set of data below.

Year	Team	Count
2011	A	5
2011	B	6
2011	C	4
2011	D	9
2012	A	8
2012	B	2
2012	C	4
2012	D	5

I want the summary table to look like the one below.

Year	Team	Count
2011	C	4
2012	B	2

The table displays the Min count per year and the corresponding teams to that min count. The part i am struggling with is pulling though the corresponding teams. I have tried first sorted value but that doesn't seem to work I need a formula that pulls through the Team

Thanks for your help

[#2]

Here you are my script:

// *****  Data Source  ***************************
Data:
LOAD * INLINE [
Year, Team, Count
2011,  A,   5
2011, B,   6
2011, C,   4
2011, D,   9
2012, A,   8
2012, B,   2
2012, C,   4
2012, D,   5
];
/*
Sort:
load
Year,
Team,
max(Count)
Resident Data Group By Year, Team;
*/
Sort:
load
Year,
min(Count) as Count
Resident Data
group by Year;

left Join

LOAD
Year,
Count,
Team
Resident Data;


drop table Data;

Hope it will help you

[Anonymous]

hi,

the following will help u for sure...

PFA

[nagaiank]

Assuming the data is loaded using the script

Data:

LOAD * INLINE [
Year, Team, Count
2011, A, 5
2011, B, 6
2011, C, 4
2011, D, 9
2012, A, 8
2012, B, 2
2012, C, 4
2012, D, 5
];

define the properties of the Summary table as below:

Dimension: Year

Expression 1 (for Team column) : FirstSortedValue(Team,Count)

Expression 2 (for Count column): FirstSortedValue(Count,Count)

With the above properties, the summary table will respond to the selections in the Data table fields.

[prasadmundewadi]

I tried this script and somehow it is not working. Here is a screenshot. FirstOrderValue always return null for me.