2 Replies Latest reply: May 3, 2012 8:48 AM by Sonika Jain RSS

    display data with '%' sign for a synthetic dimension

    Sonika Jain

      Hi all,

       

      I am stuck in a scenario where the pivot table is created from synthic dimensions using VALUELIST, lets say - A,B,C,D,E,F are the dimensions amongst which, the B is calculated as a percentage. So, I need a way to display '%' sign for a single dimension created synthetically.

       

      dimensionsutilization
      A12
      B67%
      C87
      D 35
      E48
      F78


       

      Code at the background -

      if(ValueList('A','B','C','D','E','F')='A',sum({$<Division={A}>}BALANCE),

      if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={B}>}BALANCE),

      if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={C}>}BALANCE),

      if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={D}>}BALANCE),

      if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={E}>}BALANCE),

      if(ValueList('A','B','C','D','E','F')='B',sum({$<Division={F}>}BALANCE)))))))

       

       

      Please help.

       

      Thanks in advance