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
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?