How to deriver line number for group of data.

[#1]

Let say that I have this raw data:

Data:
LOAD * Inline [
FirstId, SecondId, Start, End
1,1, 8, 10
1,1,13,15
2,1,4,5
3,1,10,14
1,2,10,13
2,2,2,4
2,2,18,19
];

And a presentation level will look like:

FirstId	SecondId	min(Start)	max(End)
1	1	8	15
1	2	10	13
2	1	4	5
2	2	2	19
3	1	10	14

But I want to see it like this:

FirstId	SecondId	LineNO	min(Start)	max(End)
1	1	1	8	10
1	1	2	13	15
1	2	1	10	13
2	1	1	4	5
2	2	1	2	4
2	2	2	18	19
3	1	1	10	14

The question is: how to calculate LineNo on presentation or script level?

Definitely, I can calc something like DataId to brake it down by line. But I need force it to begin with 1 for each unique combination of FirstId and SecondId values.

See attachments for more details.

[hector · Accepted solution]

Hi

i've made this test, and my result is the same what you asking for

See the attachment and tell us if this is correct for you

Rgds

[#3]

Thank you. This is exactly what I'm looking for.