5 Replies Latest reply on Mar 4, 2013 8:13 AM by Mark Jackson

    Can I group measures?

    Mike B

      I've got a database with 25 measures, split into 5 groups. I'm working from Excel data right now, so I can re-shape the data and give myself one "Data" field, and have the field names and their groups as dimensions, but since each field has a different format (some are numbers, some are $) it isn't really ideal.

       

      I'm thinking that I should just use each column as its own measure, but then I'd need to group them properly so they can be viewed by group.  I thought I could create a set, but apparently that isn't an option on measures.  Anyone have any idea or suggestion on how to tackle this?

       

      Thanks,

       

      Mike