sorting by expression

[#1]

Hi guys,

I need to sort my report by an expression field which is a date. I do not want to use dimension to sort.

is it possible?

Regards,

Saurabh

[preminqlik]

use this in sort expression... expression :

=only({1}Datefield)

hope this helps u ...!

[#3]

Should i use this expression in sorting expression of first dimension?

[#4]

In the report properties goto Sort tab give your expression which you want to sort the report data.

I think it will help

[preminqlik]

go to sort tab > give the above expression to required dimension ...make sure that uncheck all buttons over there....

[#6]

good explanation

[rustyfishbones · Accepted solution]

use the Sort Tab and just say =Date like below