FirstSortedValue in a Straight Table

[#1]

Hi

I am trying to get the First line of data in the following Table

Claim Number	Claim Done Date	Sum([Claimant Reserve Payment])	FirstSortedValue(Sum([Claimant Reserve Payment]), [Claim Done Date])
AE000827	03/07/2012	9108.2	-
AE000827	04/07/2012	16358.2	-
AE000827	05/07/2012	10042.2	-
AE000827	06/07/2012	10042.2	-
AE000827	09/07/2012	10042.2	-

What I was hoping for was the table just to show the first line so I know what the reserve was on the earliest date.  As you can see my expression using firstsortedvalue is just returning nulls

Can anyone help Please

Regards

Matt

[#2 · Accepted solution]

If you are using QV11 use dimension limits and show first row.

If not use the following experssion for Reserve

Sum({<[Claim Done Date]={"$(=min([Claim Done Date]))"}>} [Claimant Reserve Payment])

Regards,

Kiran Rokkam.