How do i do a sort on a dimension that's part of a cycle?

[Anonymous]

Hi Guys,

How do i do a sort on a dimension that's part of a cycle?

Thanks in advance.

[#2]

There is Sort order option in  in the Group Settings.

Please find the below image,

[Anonymous]

Thank's, but it hasn't worked for some odd reason as i'm doing an Expression Match.

=match([Grade Group],'Standard','Standard Plus','Superior','Delux','Delux Plus','Prestige','Special','Apt/Chalet','Accessible','Touring')

Do i need to put in the name of the Dimension = [Grade Group] or the Cycle name ?

[Anonymous]

Anyone know why the expression doesn't work?

[Anonymous]

try this Expression in sort tab

=if (getcurrentfield(yourgroup)=[Grade Group], match(......   like above

then only if Grade Group is visible by cycle Group it will sort according to your definitions

otherway would be to use dual when you load the definitions of your Grade Group

[Anonymous]

No, it never worked.

[Anonymous]

Have you checked that it is not being overridden by the sort order on the chart it is being used in? In my experience the sort order set in the chart will be applied first.

[Anonymous]

Yes Bella, I have checked that.  Thanks