sorting childrens pf a parent - dimensional reporting

[cognos05]

Hi,

I have a member called LATAM - NORTH and it has like 10 childrens. I want to always show Mexico as the first children. Is there a way to achieve this. Sort ascending or descending will not work here.

Descendants([LATAM-NORTH],1)

[MFGF]

Hi,

I have a member called LATAM - NORTH and it has like 10 childrens. I want to always show Mexico as the first children. Is there a way to achieve this. Sort ascending or descending will not work here.

Descendants([LATAM-NORTH],1)

Hi,

Your options for sorting members are essentially limited to the functionality the order() function gives you. This allows you to sort a set of members based on a value. Do your members have an attribute containing values in the correct sequence you would like to sort on? If so, you can use this in the order() function, but if not, you're not going to be able to do what you're asking.

MF.