Please help me in sorting the data in straight table?

[#1]

Hi All,

I need to sort by customer number as well as date in my straight table, already i tried sort option for both, they are sorting only customer number not the date.

I tried order by at backend which is also not working please advice me how to sort the data?

Actual Data
Customer ID	Date
A123	22/1/2016
A342	10/2/2016
B983	15/2/2016
C111	11/2/2016
C256	14/1/2016
D123	11/2/2016
D140	5/3/2016
A234	28/1/2016
A543	15/1/2016
C234	9/3/2016
D112	13/1/2016
B342	21/1/2016
Expected Output
Customer ID	Date
A543	15/1/2016
A123	22/1/2016
A234	28/1/2016
A342	10/2/2016
B342	21/1/2016
B983	15/2/2016
C256	14/1/2016
C111	11/2/2016
C234	9/3/2016
D112	13/1/2016
D123	11/2/2016
D140	5/3/2016

[Chanty4u]

chk dis

Rowno & interactive sorting in straight / pivot table

[Chanty4u]

u can use FirstSortedValue

[#4]

how to use first sorted value for customer and date?

[amayuresh]

Try these steps,

1. Select Date field in sort tab

2. choose Frequency option and deselect other option

3. Click Apply

4. Deselect Frequency option

5. Select Text option with A -> Z

6. Click Apply and ok

[Anonymous]

post a sample file?

[settu_periasamy]

Hi John,

May be check the attachment..

I created dummy calculated dimension like : =Left([Customer ID],1)&Date

Then you can do the normal sort : Text (A-Z) , Numeric value (Ascending)

and Uncheck the 'Allow Interactive Chart'

I think, you can do the same via Aggregation also..

[#8]

Hi,

Did you check that the date being populated is in proper Date format?

If not convert into proper date format using date(date#(Date,'DD/MM/YYYY')) at backend and try sorting.

If even that does'nt work trying converting the Date field to Number num(Date) and try.

Regards,

Reshma.

[sunny_talwar]

Stealing Settu's idea (and I hope he will have no problem from me doing that ) and made some alternation to come up with an alternative. Instead of using Customer ID as dimension, use a calculated dimension -> =Dual([Customer ID], Ord(Left([Customer ID], 1)) * 100000 + Date)