7 Replies Latest reply: Nov 17, 2015 4:55 AM by Naresh Guntur RSS

    Count by Dimension

    Naresh Guntur

      Hi,

       

      Don't mind if it is too simple.

       

      LOAD * Inline [

      A, B, C

      a1, b1, c1

      a2, b2, c2

      a3, b3, c3

      a4, b4, c4

      a4, b5, c5

      a1, b6, c6

      a2, b7, c7

      a3, b8, c8

      ];

       

      I have a table like above and I need a chart with A & B as dimensions

       

      I need the below output.

       

      I want (3rd column)the count of C aggregated at A irrespective of B so that I can (4th column)count the % of B according to the total values of A

       

       

         

      ABCount C at Level ACount B
      a1b120.5
      a1b620.5
      a2b220.5
      a2b720.5
      a3b320.5
      a3b820.5
      a4b420.5
      a4b520.5

       

       

      Cheers,

      Naresh