issue with sorting

[philelmousse]

Hello,

I would like to sort a data item built like this :

#prompt('p_Time','token','[REPORTING LAYER].[Time].[Time]')#

In my prompt the user can choose if he wants to display the data by month, day or hour. But when I set the advance sorting option for this data item to (year, month, day, hour) the result is not correct.

How correct the problem ?

Thanks

[pricter]

If you are a dimentional model then use the "order" function in order to achieve the desirable sorting.

If you are using a relational model did you add this data item to the properties of the list/crosstab whatever r you using?