Sorting manually

[#1]

Hi all,

I have a problem in sorting by dimension with some condition.

My dimension fields are

A

B

C

D

E

F

My requirement is I need to sort it out alphabetical order A-Z with 'D' at last row.

Waiting for help.

[#2]

Hi Veman

please sorting your dimension by this experiences

wildmatch(Month_Name,'A','B','C','E','F','G','H','I','J','K','L','D')

Regards

Ashish

[#3]

you can use sort by using this expression:

if(letter = 'D', 1000000, ord(letter))

it means you will sort letter by their ascii values for all letters except D which will get 10000000 instead of the normal value, thus going at last row