4 Replies Latest reply: Dec 22, 2017 5:41 AM by Hans Christian Riis RSS

    Add member (sum of other members) to a dimension?

    Hans Christian Riis

      Hi all,

       

      I'm not quite sure how to formulate this question, but wondering if it's possible to manipulate Dimension in a way, so a new member is added?

       

      If I have a dimension REGION:

       

      Load * inline

      [

      Region

      a

      b

      c

      d

      ];

       

      Is it possible to modify this dimension to include a member "All Regions", which equals a-d all together ?

      Could it be made in a calculated Dimension, in the load script, or in the Graph itself?

       

      I would like to have a Member called ALL Regions and be shown as a bar with 104 in the simple graph below. Is it possible?

       

      a.png