interactive Row number

[todtliat01]

I have a project where I want to number the rows in the chart. However I want rows with the same value on the field x, to stay the same. So for example rows 5-7 will indicate 5 and the next row will be 6 rather than 8 and so on.

I am attaching a sample qvw

Thanks

Liat

Vatat_Tat_Tkufa.PROJECT	Vatat_Tat_Tkufa.TEUD_ZEHUT	RowNum
		35
700079	067168666	1
700100	008164071	2
700141	000000077	3
700142	000000082	4
700200	005185574	5
700200	011134384	6
700200	050348952	7
700201	009805995	8
700202	005393194	9
700202	041383126	10
700203	005185574	11
700203	050348952	12
700204	053581849	13
700205	011134384	14
700205	069002426	15
700206	011134384	16
700206	069002426	17
700207	065248015	18
700208	009805995	19
700208	043594449	20
700209	041383126	21
700209	064439243	22
700210	009805995	23
700210	043594449	24
700210	056023575	25
700211	041383126	26
700212	009805995	27
700213	041383126	28
700213	064439243	29
700214	041383126	30
700215	041383126	31
700216	041383126	32
700216	064439243	33
700217	041383126	34
700217	064439243	35

[ecolomer]

Is that you need?

[its_anandrjs]

You can use calculated dimension also.

Dim1:-  =Aggr( Rank( -Vatat_Tat_Tkufa.PROJECT), Vatat_Tat_Tkufa.PROJECT)

Dim2:- Vatat_Tat_Tkufa.TEUD_ZEHUT

Expre:- Only( Vatat_Tat_Tkufa.PROJECT )

Regards

Anand

[ecolomer]

more ..

[todtliat01]

That really helped but I have another question. I have more dimensions that are the sort of the table, I would like to rank according to them as well. I am attaching the new file.

Thanks for all your help.

Liat

[ecolomer]

Sorry but the file are wrong

Can you upload one more

[todtliat01]

another try

[ecolomer]

Now is OK,

What is the new requeriment?

the rank for another column?

[todtliat01]

I have a constant sort: Sponsor, Project, ID. I need the row numbers to advance but if I have more than one line on the Project, all the lines for this project should be the same and advance afterwards without skipping numbers. Much like what you have done, only the Sponsor column needs to be part of the rank and the sort.

Thanks Liat

[ecolomer]

Is this?