Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
How about if you create your dimension like this
(Year * 100) + Month
and then sort nuemerically
How about if you create your dimension like this
(Year * 100) + Month
and then sort nuemerically