sorting issue

[BIsrik]

hi,

i have a sort issue of this kind.

I have 2 levels in a dimension. days group and days. days group are <15 days, <1month

when i sort the days group it gets sorted in this fashion <1month and <15 days. According to powerplay this is r8 but for user it is not the sorting required. It should have been <15 days and then <1month. This could be done by using the order value in each category of the days group. But this involves some manual work. if in future if any other category is added to the level the sorting may change. then it involves some manual work. Is there any work around for this to happen automatically.

srik

[Darek]

Yes, have a calculated column which will return naturaly sortable values. It would use same conditions as your existing one, just different output, say 1,2,3,...

[BIsrik]

can u explain me more. i couldn't get what u were saying

[Darek]

I am guessing here, but I think your current calculation says saomething like:

case
when a then '<15 days'
when b then '<1 month'
else '>1 month'
end

add another calculation

case
when a then 0
when b then 1
else 2
end

and use it for sorting

[BIsrik]

i got an still easy way of doing this..I just gave the column days for the sorting column in the days group level. It did the work...

Anyway thanks for the soln.