Enforcing User-defined sort order

[karkia]

Can we define the order in which my dimensions appear? For example, I need to get this -
#ofDays
-------
>150
101-150
51-100
1-50
But I get this-
#ofDays
-------
101-150
>150
1-50
51-100
Ascending or Descending would only reverse the order.

 

[skrandel]

Sorting ignores special characters.

You won't like the answer, but there are no custom sorts in WebI.

Change your values so that they are alphabetically in order

151+
101-150
051-100
001-050

This works. It doesn't look great, but it does the trick.

When you get custom sorts in XIR2, then you can make it work the way you want.

Steve Krandel
Symantec

 

[karkia]

Thanks Steve. With this lousy WebI, I guess your trick seems to be the only way out.