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
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
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
Add a comment