This content has been marked as final. Show 3 replies
I have created a straight table that produces results as below image. D is derived frrom Dimension, and E derives from Expressions.
For the Dimension, DATE, it is a calculated dimension that combines month (in text format) and Fiscal Year (in numerical format) using expression [= [MONTH(MMM)]& " "& FY ]
Below is the sorting properties for DATE, I tried every options and the results are not sorting the months correctly, what can I do to resolve that?