Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
will you please check following link , I think some similarity in porblem ??
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 ...
Hi,
try ' S.NO' & rank(S.NO) in expresssion
Hope this will not change even if you change(sort) any dimension ?
did you try using sort by expression the getaway dim by sum(S.NO)?
see the attached.
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.
Hi Alluriah,
I tried to make a dimension with your mentioned formula , but it is giving me an invalid dimension
Hi All,
Has anyone found any solution for this concern ?