Cyclic Group Sorting order issue.

[suresh_qv50]

Hi EveryOne,

I have created 2 Straight tables,

1. Table1(ACH)  is created ACHTable (cyclic group ) as dimension.

Group has dimensions Store,BankName,BankRouting,Statementnumber,Attempt,isdirectDeposit etc.

here problem is for bankname and bank routing sorting is not working. i need frequency Desc for Bankname and bankrouting.

for Annualincomebin field the UnAvailable is showing first but we need at last.

2.Same Issue in Dc table too

I Have attached .qvw please go throught it and revert back ASAP.

Thanks in advance.

[settu_periasamy]

may be like attached?

1.ACH Chart

Promote your Expression (Sent) as Top -> Sort By -> Numeric Value -> Descending

2. DcTable

Promote your Count Expression to top -> Sort By -> Numeric Value-> Descending

Remove other sort by options..

[settu_periasamy]

Your sample attached

[suresh_qv50]

Hi settu_periasamy,

Thanks for immediate response,

That was working in case of bankname and bankrouting perfect. but i need store -->numerical Asc,

Statementnumber --> numerical asc, Attempt --> num asc,

Payfrequency --> Match Exp, like wise etc.

By this change it was changing the remaining dimensions sorting order.

2. In any field have Unavailable, it should be at last of data like

For Exp:

PayFrequency

weekly

Bi_weekly

semi_monthly

Monthly

UnAvailable