2 Replies Latest reply on May 29, 2015 9:21 AM by Harley Ellenberger

    using a dimension as a measure value

    Harley Ellenberger

      I know that I can't use a dimension as a measure value, but I'm trying to create a simple crosstab view that includes a dimension as a column next to two numeric measures.

      'Sheet 1' shows my table with the two numeric measures.  I simply want to add my 'Buy Notes' dimension as a 3rd column to the left of the GRP field.

      'Sheet 2' uses the technique presented here - How do I include a disaggreagated (or at least a max/min) string as one of my measure values?


      This gets me close to what I need but I don't want the 'Buy Notes' field to be summed in my row and column totals.  I also lose the ability to show my GRP and Buy Amount column headers.


      Any other way of accomplishing this?