5 Replies Latest reply on Sep 8, 2016 6:33 PM by lei.chen.0 Branched to a new discussion.

# Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hi,

I got a problem with creating custom sort based on parameter. I need to sort below numbers with parameter control with alphabetical and reverse-alphabetical sort but "Before Last" and "Last" values should be always at the end ( not included in sorting)  I've attached my example in twbx can anyone can help me with that

 B5 5 K1 2 M3 1 Before Last 21 B2 2 C5 8 I4 4 C2 7 A1 1 L2 3 Last 33 N1 8 O2 2 P1 1 A2 4 J2 3 E1 2 E3 6
• ###### 1. Re: Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hello Lucasz,

Please refer to the attache workbook for details.

Regards.

• ###### 2. Re: Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hi Lei,

Thank you for this solution. I've forgot one thing - Is this possible in [Z-A] sort to keep letters in reverse-alphabetical order but numbers in ascending order?

Example:

C1

C2

C3

B2

B1

A2

A1

• ###### 3. Re: Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hello Lukasz,

It's possible.

I revised the workbook.

Regards.

1 of 1 people found this helpful
• ###### 4. Re: Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hi Lei,

I found another problem with sorting - this time on cross tab. When I include sort variable columns being duplicated. I've attached sample report.

• ###### 5. Re: Sort Dimension by parameter [A-Z] & [Z-A] and constant values

Hello Lukasz,

I have two questions.

When I include sort variable columns being duplicated.

What does "duplicated" mean here?

And what's the sort requirements for the cross table?

Regards.