Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Month order is not sorted , i removed all the sorting and tried all the sorting as well , I need it to be displayed in the order like from Jan , feb .. Dec)
HI
Month Year field is created with MonthName function? or Month &' '& Year field?
If its created based on MonthName fn, its has dual values, so, it will sort by default.
Try with Num(Month Year) in sort expresssion...
I am a tad suspicious about the fact that both out-of-order months are showing an identical value to the month they're next to. It might be unrelated, but there might be an issue with whatever formula you used to make these months that is causing a mismatched dual (the numeric value matches one month while the text value is another). Worth checking that out if nothing else surfaces. You can also test for this by using num(Month Year) as your dimension and see if you get the correct values for each month.
Tried using Num(Month Year) in the dimension , but the result is still the same
Num(month year) inn the sort expression also did not work
Have you tried generating a serial number in your calendar and sorting by that instead
Autonumber(Period,'PeriodID') as [PeriodID]
Thanks Everyone , I tried creating a Master Dimension called Month year and then added it , it worked