3 Replies Latest reply on Sep 25, 2011 4:03 PM by Bohdan Kosenko

    Can I group measures?

    . Bernie

      Hi,

       

      I have a dataset with about 100 measures (columns in a spreadsheet). These measures can be grouped into a smaller number of categories.

       

      e.g.

      measure 1

      measure 2

      measure 3

      measure 4

      ...

      measure 100

       

      Can I somehow create these categories?

      e.g.

      new field "category 1" consisting of measure 1 and 2, "category 2" consisting of measure x, y, ... z and so on?

      (basically, I want to combine columns into one column per category)

       

       

      I tried groups and sets but that didn't work.

       

      Your help is highly appreciated.