concatenate year and month Sorting issue

[niranjan_capgemnini]

Hi experts,

 i am trying to do sorting after concatenating the year and month field in the bar chart but it is not sorting properly.

In the dimension i have used below field
num(Year)&num(Month)

In sorting column i have used below one

num(Year)&num(Month)

it is sorting only 1 to 9 months for all years(2017,2018,2016) but 10 to 12 months showing last .

please give any suggestion.

[sunny_talwar · Accepted solution]

How about if you create your dimension like this

(Year * 100) + Month

and then sort nuemerically

[niranjan_capgemnini]

Hi Sunny_talwar,

Thank you very much for giving suggestion... it is working fine for me...