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

    Can I group measures?

    . Bernie



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



      measure 1

      measure 2

      measure 3

      measure 4


      measure 100


      Can I somehow create these categories?


      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.