Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.