Row numbering by two dimension

[#1]

Hello all,

I have a problem when I put RowNo to the straight table, ordering by field changed. Idea to get in result the following:

#	A	B	Value
1	AA	DD	687
2	BB	DD	566
3	AA	SS	345
4	GG	DD	111

Thanks in advance!

[#2]

The result now:

A	B	Value	Alt(Above(Column(2))+1, 1)
AA	SS	345	1
BB	DD	687	2
BB	DD	566	3
GG	DD	111	4

And it is not correct, Value field should be ordered as descend.

Correct result shoud be as

customRowNo	A	B	Value
1	AA	DD	687
2	BB	DD	566
3	AA	SS	345
4	GG	DD	111

[jonathandienst]

Then sort the table by Value and drag the row no to the left.

Jonathan

[#4]

Sorry, but it doesn't work.

[jonathandienst · Accepted solution]

You can try this:

Rank(Total Aggr(Sum(Value), A, B))

See the attached. However, if you reverse the sort of value, the count will reverse as well.

Jonathan

[#6]

Thanks a lot Jonathan, it works perfectly!!!

[#7]

Hi JOnathan,

Thanks for this.

Can you please let me know how can I get Rank in Reverse Order for the descending Sorted values?

Thanks in Advance

Regards,

Susvith

[#8]

something like that:

Rank(Total Aggr(Sum(Value)*-1, A, B))