10 Replies Latest reply: Oct 13, 2011 8:08 AM by Anand Chouhan RSS

    Date ascending or descending order



      I have an excel file (*.csv) which has one filed that contains timestamp values Ex. 07/21/2011 16:40:43, etc...

      Now i have manged to convert into Date format 'MM/DD/YYYY'.

      Chart Dimension: Date(Date#(Left([Event Timestamp],10),'MM/DD/YYYY'),'MM/DD/YYYY')


      But how can i sort above dimension by ascending/descending order? I have tried several option using Sort tab but no luck.


      Any idea?