8 Replies Latest reply: Jul 29, 2015 5:21 AM by Jordi Arenas RSS

    Help creating matrix with Pivot/table

    Paul Steinborn

      Dear Community,

       

      i need help to achieve following table (vertical:A,horizontal:S,Values: count of S appear) :

      1.png

      with following data:

       

      A_S:

      LOAD * INLINE [

          A, S

          1, 1

          1, 2

          1, 4

          1, 4

          1, 5

          2, 1

          3, 2

          3, 2

          4, 1

          5, 1

      ];

       

      Actually i only achieve this:

      2.png

      Horizontal 1 ... 5 are Expressions like if(S=1,COUNT(S)) ... if(S=5,COUNT(S))

      I dont want to display the S Dimension, and want the counted results of S for A, so only one row and not broke up over all S possibilities.

       

      Please help!