5 Replies Latest reply: Aug 31, 2011 9:49 AM by Jairish Ramsanjhal RSS

    Add static dimension value in a pivot table

    Jairish Ramsanjhal

      Dear all,

       

      I have a dimension called Category and have some postal codes within it.

       

      What I would like to do in this dimension is to add new values in the category like A102, A104 based on age to make some calculations with this new dimension in the expression field. I know I can do this with add calculated dimension but I can not manage this. I tried using this code

       

      =IF([Age client]>=18,'A102',

       

      IF([Age client]<18,'A104',[Category]))

       

      But then only A102 and A104 remain as dimension while the others A101, A103 and A107 are gone because they fall outside the criteria of age. How can I achieve this?

       

      The dimension looks like this:

       

      Category

      A101

      A103

      A107

       

      And ultimately should look like this:

      Category

      A101

      A102

      A103

      A104

      A107

       

      Thanks in advance for your thoughts.

       

      Regards,

       

      Rishi