5 Replies Latest reply: Feb 6, 2013 3:09 PM by Robyn Talley RSS

    Sort by calculated dimension in pivot table

      I am trying to sort my piovt table by a calculated dimension that has a label.  Can this be done?  Below is my calculated dimension...

       

      if(fsbp.FaceAmount <= '14999' , '<15k',

       

      if(fsbp.FaceAmount = '15000', '15k',

       

      if(fsbp.FaceAmount > '15000' and fsbp.FaceAmount < '20000', '>15.01K<20k',

       

      if(fsbp.FaceAmount = '20000', '20k',

       

      if(fsbp.FaceAmount > '20000' and fsbp.FaceAmount < '30000', '>20.01K<30k',

       

      if(fsbp.FaceAmount = '30000', '30k',

       

      if(fsbp.FaceAmount > '30000', '>30k')))))))

       

       

      The label name is WholeLifeCoverage.  I want the sort to be in the same order as my expression above.

       

      <15K

      15k

      <15.01K<20K

      20K

      >20.01K<30K

      30K

      >30K

       

      Thanks!