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:
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.