11 Replies Latest reply on Nov 13, 2015 4:10 AM by Mejo Kuriachan

    multiple measures if each row in excel only contains one piece of data

    Cash East

      Hello, I am struggling with the concept of "each row containing only one piece of data". When I use the excel add in to reshape my data, and the columns become integrated under a single, general "category" column, I seem to lose the ability to identify individual measures (I want to analyze using each of the former column headings). For example:

      Product     Sales      Profit     Margin    

      Widget A     $500     $100     20%

       

      Becomes:

       

      Product     Category     Value

      Widget A     Sales        $500

      Widget A     Profit         $100

      Widget A     Margin        20%

       

      How can I create unique measures from each crosstab column after I have used the data shaper? Or should I not be reshaping this data?

       

      Thanks!!!