Custom sorting

[n1ef5ng1]

Hi all,

I have this Region Code field name 10,20,30,40,50,61,62,70,81,82

I would like it to sort in this order in one of my particular report, 10,20,30,50,61,62,40,82,81

I tried using Match, WildMatch on Sort -> Expression but it does not work

I am not able to edit any scripting pertaining to this problem I am facing

Is there any way I can do this custom sorting

Thanks

[CELAMBARASAN · Accepted solution]

Did you tried with sort by expression option and expression as

Match(RegionCode,10,20,30,50,61,62,40,82,81)

It will works. if not can you share the sample file?

Or use Load order

Before loading your data table you have to use inline load first as

LoadOrder:

Load * Inline [

RegionCode

70

10

20

30

50

61

62

40

82

81];

[n1ef5ng1]

you are right. however I just realized the main cause of my problem is that I want to sort calculated dimension instead of normal dimension; if is normal dimension i would be able to use match, any body can solve this issue

[CELAMBARASAN]

Calculated dimension based on what criteria?

[Kushal_Chawda]

Create inline table in order you want to sort

in your case as below

load * inline [

RegionCode, Sort

10,1

20,2

30,3

50,4

61,5

62,6

40,7

82,8

81,9 ];

Now go to chart properties>sort tab in expression use Sort filed