1 Reply Latest reply: Jun 3, 2012 2:18 AM by Edgar Baltazar RSS

    conditional sorting of the rows of a dimension which has been transposed to make the columns in a pivot table

      hi

       

      I have developed a report in which i have used a  calculated dimension to make columns for the expression by transposing it,

      year_cd & '-' & month_cd, this calculated dimension has been created. its value is like this py-jan,py-feb...

      .....py-dec.

       

      Now the data is refreshed after every month, and the reports are based on the data of the 12 months.

       

      i need to show this dimension in a pattern which changes every month, its like

       

      for jan, it must start with py-jan,py-feb......

      for feb,it must start with py-feb,py-mar........py-jan.

       

      and so on till december.

       

      How can i achieve that????