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

    Straight Table Object Sorted by Dimension

      Hi,

      I have created a straight table that produces results as below image. D is derived frrom Dimension, and E derives from Expressions.

      Capture.JPG

       

      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?

      Capture1.JPG