Troubleshooting Data Selection within Table Object

[Anonymous]

Hi all - quick question on data selection within a Table object.

My data is structured as:

Group ID	Area	Stop	Time
1234	A	A1	4:55
1234	A	A2	5:10
1234	A	A3	5:15
5678	B	B1	7:10
5678	B	B2	7:15

Where the first [Stop] record in each [Group ID] (e.g. A1, B1) represents origin and the last (e.g. A3, B2) represents destination.

I need to display a Table object that shows origin for each [Group ID] e.g.:

Group ID	Area	Stop	Time
1234	A	A1	4:55
5678	B	B1	7:10

Unfortunately using First([Stop]) or FirstSortedValue([Stop],[Time]) as a measure column in the table returns a blank value.

Any ideas? Thank you.

[Thiago_Justen_]

I'd suggest you something like this:

FirstSortedValue (Stop,-Aggr (Time,[Group ID]))

Make sure Time field is on right format.

[Qrishna]

PSA.