Straight Table Object Sorted by Dimension

[#1]

Hi,

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?

[brijesh1991 · Accepted solution]

Ronnie,

Just Promote the DATE field on top in Sorting tab and then apply sorting as per your requirement.

[#3]

Hi Brijesh, works perfectly now! Thank you sir.

[#4]

It worked for me as well

Thanks Brijesh