11 Replies Latest reply: Sep 25, 2018 9:01 AM by Juraj Misina RSS

    Create dimension from two dimensions

    Daniel Rodríguez

      Hi All

       

      I have two dimensions as follows:

       

      Dimension1Dimension2
      AA.1
      AA.2
      BB.1
      BB.2

       

      and I want to create the following dimensions

       

      New dimensionsTotal
      Asum where dimensions2 in (A.1,A.2)
      Bsum where dimensions2 in (B.1,B.2)
      Csum where dimensions2 in (A.2,B.2)

       

       

      How can I create that?

       

      Thanks in advance

       

      Regards