Chart Sort of text (Date)

[Anonymous]

I have the below chart... and the sort on the Month is desc numeric. When I sort from ASC (which I want to show from Left to Right starting at 201611, 201612, 201701 (opposite of what you see below) I'm not getting 201611, 201612, 201701 which is want I need. I'm thinking it's because the dimension is a text value and not date. Anyway, how would I get my desired results. Attached is a sample of a chart.

[sunny_talwar · Accepted solution]

Try this with ascending sort:

=If(NoOfRows() - RowNo() < 3, (Count({<[MBR_ACTIVE_AT_MONTH_END] = {"1"}>}MBR_ACTIVE_CLT_CLT_PGMID) ) )

[buzzy996]

hi,can u try tis way..in ur load script along with data create a new field with numeric value

urdate,numericfield

201701,1

201612,2

201611,3

and load same as sequence above by using order by numerifield

HTH.