Former Member

# Custom Sort in webi

Hi,

I have created a variable which gives ranges of Amount.

\$0-\$25K

\$25k-\$50k

\$50k-\$100k

\$100k-\$250k

\$250k-\$500k

>\$500K

so that we can check number of invoices coming in the range.

Since Range is a dimension values are getting sorted by itself and when I am doing custom sort system is not accepting custom sort.

It shows in below way:

\$0-\$25K

\$100k-\$250k

\$250k-\$500k

\$25k-\$50k

>\$500K

\$50k-\$100k

Please guide to get correct sort order.

Thanks,

Ankit

10|10000 characters needed characters exceeded

### Related questions

• Posted on Nov 04, 2015 at 12:07 PM

Hi,

Share the manage sort screenshot.

See the attached screenshot.If you will manually rearrange the order then order will come correct in the table.

Amit

Untitled.png (30.9 kB)
10|10000 characters needed characters exceeded
• Former Member AMIT KUMAR

Did same thing but I have added linking from this table to another table so when I click on any cell for navigation then in input control it shows both variables as in:

Var_Spend1 = B\$25K-50K

Var_Spend2 = \$25K-50K

That can be annoying for users.

So I am looking for any other work around.

Thanks,

Ankit

• Former Member
Posted on Nov 04, 2015 at 02:01 PM

Hi Ankit,

As you are using XI 4.1, you can use hide column feature.

Create a variable as follows:

[sort] = If ( [range] = "\$0-\$25K") Then 1

Else If ([range] = "\$25k-\$50k") Then 2

Else If ([range] = "\$50k-\$100k" )Then 3

Else If ([range] = "\$100k-\$250k") Then 4

Else If ([range] = "\$250k-\$500k" ) Then 5

Else 6

Put this [sort] column in your column, sort it in ascending order and hide it.

Hope it will help.

Regards,

Yuvraj

10|10000 characters needed characters exceeded
• Sateesh Kumar Bukkisham Former Member

Hi Ankit ,

Hope you read the NOTE attached by Amit . It's by behavior, if you are using Calculation context operators in the variable derivation .

Is the report on BW. If not try creating the logic in universe .