2 Replies Latest reply: Mar 29, 2017 5:36 PM by Marco Wedel RSS

    Many to One Calculated Dimension

    Trey Smithq

      Is there a way to create a many to one relationship dimension with an expression?

       

      What I am trying to get is something like this:

       

      Dimension:

      Company,

      A,

      B

      C.

       

       

      Chart:

      Company            Sales

      All                       350

      A                         100

      B                         200

      C                         50

       

       

      If I can create this then I believe there is a way to have users do custom groupings in ad hoc reports. They like to group a sub set of values and compare against the total and regular values. The only solutions I could find involved macros or grouping the dimension into groups keeping the one to one relationship, both of which would not work for my need.