6 Replies Latest reply: Jun 23, 2017 3:01 PM by Wallo Atkinson RSS

    Date sorting

    RUPALI ETHAPE

      Hi Experts,

       

      I have YearMonth Column in my datamodel which is like this ...

      2016-Apr

      2016-May

      2016-Jun

      2016-Jul

      2016-Aug

      2016-Sep

      2016-Oct

      2016-Nov

      2016-Dec

      2017-Jan

      2017-Feb

      2017-Mar

      2017-Apr

      2017-May

      2017-Jun

       

       

      but when I fetched this column against any dimension in pivot it can not come in same order.It is coming like this

       

       

      2016-Apr

      2016-Aug

      2016-Jun

      2016-Jul

       

      What would be the  right way to sort this column in same fin order.

      Thanks,

       

      Rupali