wan to implement rank function on bases of 2 columns

[ysalvi4321]

Hello Team,

I want to achieve rank on the bases of two columns, attaching raw data for your reference, and implemented the rank function on the front end but it didn't work.

Can you please tell me how we can acheive row number (col C ) as Output.

Thanks in Advance

[Prem0212]

I think your Question is not clear to understand and i am giving an example here with an expression    Aggr(Rank(sum(Sales)), Region, City).   This function calculates the rank based on two fields Region and City

[Rams-]

Hi,

You can use the following expression which is based on:

sum([Quo No]) + sum(Quotation)

I have applied the following expression:

Aggr(Rank(sum(Quotation)+sum([Quo No])), Quotation, [Quo No]),  you can label this expression as Row Number

Output:

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[ysalvi4321]

Is this possible to implement the same logic in the backend??

[Rams-]

You can use the sum function in backend, but for aggr and rank function you have to do it in front end

[Kushal_Chawda]

@ysalvi4321  try below

Data:
Load * Inline [
Quotation, Quo No
1,1
1,2
1,3
2,1
2,2 ];

New:
Load *,
AutoNumber(RecNo(),Quotation) as Rank
Resident Data
Order by Quotation,[Quo No] desc;

Drop Table Data;