Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..
Your sample attached
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