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

    Date ascending or descending order

    Dipesh Patel

      Hello,

       

      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?

      Thanks,

      Dinesh