18 Replies Latest reply: Sep 2, 2014 3:55 PM by Marco Wedel RSS

    Sorting the quarters of a year

      Hi

      I have a dimension  which i need to sort the values are as follows

      q111 which means q1 of year 2011,q211 which means q2 of 2011...

      so it is scrambled as in q111,q314,q412,q212..and so on

      I would like to sort it as

      q111,q211,q311,q411,q112,q212,q312,q412,q113.. and so on

      Can anyone help me build the expression for the sorting

      Thanks