3 Replies Latest reply: Aug 4, 2014 2:01 PM by Petrova Sinny RSS

    Straight Table Object Sorted by Dimension


      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?