8 Replies Latest reply: Nov 6, 2017 10:50 AM by Sunny Talwar RSS

    Date format

    Satish Kamath

      Hi All

       

      I have dimension as below

       

      =Month(CalDate) & ' ' & chr(39) & Right(Year(CalDate), 2) which gives me dimension as Jan '16, Feb '16 and so on (and this is fine)

      I also have columns CallMonth as 1,2,3...12 and CallYear as 2016 & 2017 in my Data model

       

      With this I' m unable to sort date

      I have also tried to sort with below two

      1. CallYear & CallMonth

      2. Num(CallYear & CallMonth) both

       

       

      Still the issue to sort

       

      Thanks in advance