Sorting

[deepakqlikview_123]

Hi All,

PFA.

I want to show YTDMAY2014 after YTDMAY2013.Is it possible.

Tight now I am using Sorting by Ascending order Year and Text from A-Z.

Below is my calculated dimension

=if(MONTH='May','YTD' &MONTH &YEAR,if(MONTH='Jan' or MONTH='Dec',YEAR))

Thanks

[Anonymous]

share your sample aaplication

[ankitaag]

Hello Deepak,

Kindly refer the attached application for the answer to your question.

In the sorting tab of the chart you need to write an expression as mentioned in the qvw attached.

If you are looking for something else then please share the sample data you are working on.

Thanks and Regards,

Ankita