Rank in table

[#1]

Hi ,

I am facing an issue in rank function. Scenario is I need to create a table where there are multiple dim and measure and one rank column.

Serial No working as a primary key, Gateway is a dim and rest are measures:

S.NO	Gateway	Total Sale	Total Waybill	Actual Weight	Charge Weight
1	BANGALORE	2,454,840	1,113	178,394	198,321
2	CHENNAI	2,236,050	585	173,361	210,762
3	DELHI	2,103,823	851	149,282	173,547
4	GREATER MUMBAI	2,050,251	965	131,233	158,786

Now if I Sort the table on the basis of CHARGE WEIGHT It will give me the result below one :

Gateway	Sum([S.NO])	Sum([Total Sale])	Sum([Actual Weight])	Sum([Charge Weight])	Sum([Total Waybill])
CHENNAI	2	2236050	173361	210762	585
BANGALORE	1	2454840	178394	198321	1113
DELHI	3	2103823	149282	173547	851
GREATER MUMBAI	4	2050251	131233	158786	965

But My Requirement is below one

Gateway	Sum([S.NO])	Sum([Total Sale])	Sum([Actual Weight])	Sum([Charge Weight])	Sum([Total Waybill])
CHENNAI	1	2236050	173361	210762	585
BANGALORE	2	2454840	178394	198321	1113
DELHI	3	2103823	149282	173547	851
GREATER MUMBAI	4	2050251	131233	158786	965

So conclusion is , If there is a key like Serial no it will not let me sort on the basis of measure , You can add a dimension at Edit option and see  and if I remove the serial no it will let me sort on the basis of any measure but I am looking for a solution which let me sort even if Serial No is in table .

I am attaching an app where I have added one rank column and you can see sort is not working

[Anonymous]

Hi

will you please check following link , I think some similarity in porblem ??

Help needed with ranking selections!!!

[#3]

I Think you mentioned link has some other issue than what I have.

I have multiple dimensions and measures in my table and I need a rank columns which works from 1 to last one always when I perform sorting on the basis of any measure . I have added a new column ROWNO() but it makes me can't sort the table. and If I added serial no as rank , it get also change the number with sorting. As Serial No should always comes as 1,2,3,4,...100 not like 1,10,5,,9 ...

[Anonymous]

Hi,

try '   S.NO' & rank(S.NO)  in expresssion

Hope this will not change even if you change(sort) any dimension ?

[idogridish2]

hi rohitkumar1609

did you try using sort by expression the getaway dim by sum(S.NO)?

see the attached.

[#6]

HI Ido,

the sheet you have attached , there is no sorting working on any measure , I need sorting will work on any measure or any dimension but serial no or row no will not change, Its like There are 5 measure and I sort on measure one , so the serial no will be 1, 2,3,4,.. same works for every measure.

[#7]

Hi Alluriah,

I tried to make a dimension with your mentioned formula ,  but it is giving me an invalid dimension

[#8]

Hi All,

Has anyone found any solution for this concern ?