Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
u can use FirstSortedValue
how to use first sorted value for customer and date?
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
post a sample file?
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..
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.
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)