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:










      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.